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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Rich Stanek" wrote:

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