Hi Stephen

You can do it with CF
Formula Is =(A1-B1)A1=10% format Red
Formula Is =(A1-B1)/A1<=-10% format Yellow

--
Regards
Roger Govier

"Stephen" wrote in message
...
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!