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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting Plus/Minus a Percent
- Thread starter Cachilupi
- Start date
chuggins143
Board Regular
- Joined
- Nov 10, 2009
- Messages
- 100
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.
#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.
Upvote
0
