Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Folks,
I have two columns that calculate out to be percentages. I'd like to compare one against the other and color the cell based on a +/- 10%. ei; A1 = 90% B1 = 100% -since A1 is - 10% of B1, then color cell A1 font color Red. ** ei; A1 = 100% B1 = 90% -since A1 is + 10% of B1, then color cell A1 cell color Yellow. I'm not sure if I can do this with straight up conditional formatting or if I need this to run in some sort of code? Any help is greatly appreciated! TIA! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting Problem | New Users to Excel | |||
Formatting problem | Excel Programming | |||
formatting problem | Excel Discussion (Misc queries) | |||
formatting problem | Excel Discussion (Misc queries) | |||
Formatting Problem | Excel Programming |