Cell Formatting

[Guest]

I am looking for a fomula or macro that will change the formattion of a cell
based on the result.

Example: If the actual revenue is 90% or less of the budgeted revenue then
change the cell color to red. If the actual revenue is 105% or more of the
budgeted revenue then change the cell color to blue.

Any ideas?

Thanks

 

[Guest]

Look at Conditional Formatting. It is under Format in the menu.

You have two methods of choosing the basis for the conditional - actual
value of the cell itself, or a formula that can evaluate the value of yet
another cell. You may have up to 3 conditions set to change the format of
the cell, so that gives you 4 format options (doesn't meet any of the
criteria, plus meets 1 of the other 3).


If your percentage is in the formula you're wanting to change colors on, you
can use Cell Value Is
and greater than or equal to 1.05 and set color Blue for one condition
and set another for less than or equal to .9 and set color to red.

 

[Guest]

In the format pull down there is conditional formating.

 

[Guest]

It sounds like you just need to use conditional formatting
(\Format\Conditional Formatting). You can have up to 3 conditions with
different formats (plus a fourth, if you count the original - i.e. no special
conditions met).
Will

 

[Guest]

You want conditional formatting, which is accessible via the Format menu.

For the first condition, enter the formula =A1<=B1*.9 then format red
For the second condition, enter the formula = A1>=B1*1.05 then format blue

This assumes that the budgeted revenue is in B1 and A1 has actual revenue.
Adjust the formulas above to suit how your spreadsheet is designed.

Dave