Search results

I will check this when I get home. We have this web filtering program here at work called Websense, which is nonsense, and it's blocking me from you link. GRRRRR

I may have to rethink my scorecard and not use the icon feature but simply color in the cells. I've been able to use them for every other scenario but this one. Thanks for your input I really appreciate it.

Hi Luke. I set up a spreadhsheet using your formatting and it worked. Here's the issue I have. I want to be able to show the forecast variance as 120%. The formula you provided for C2 displays the number 2 which won't have meaning to my audience. Is there another way to skin this cat so I can...

Thanks for Jason and Luke for your responses. I will take a look at your suggestions today and see if I can make them work. My spreadsheet is set up a little differently. I have the Forecast value stacked on top of the actual value. It looks like: Forecast 100 call this cell B1 Actual...

Hello. I want to use Icons in Conditional Formatting for a scorecard. The scenario is that we calculate sales forecast accuracy by dividing actual sales by the forecast. So assuming the sales forecast is 100 and the actual sales are 120, the accuracy is 120/100 or 120%. What I want to do is to...

I am trying to use Icon sets in conditional formatting for a dashboard application. I am tracking actual sales versus forecasted sales by calculating the forecast accuracy. For example if the forecast was 100 and actual sales were 120 the forecast accuracy would be 120/100 or 120%. I want to...