Conditional Formatting Plus/Minus a Percent

[Cachilupi]

I am using Excel 2007. I have a simple conditional formatting formula that changes colors depending on if column F (Actuals) is greater than or less than column E (budgeted amt). Is there a way to have the formula be if Actuals +/- 5% > Budgeted amt change the color?

 

[chuggins143]

I'd do it with two conditional formats one for over and one for under...

#1 "Cell Value Is", "greater than", "=$C$14+($C$14*0.05)"
#2 "Cell Value Is", "less than", "=$C$14-($C$14*0.05)"

Set the colors as you see fit.

Good luck!
Chad

edit... of course I'm using 2003 so there might be some differences.