Formula

[Jacque]

I want to write a conditional formula where if A1 is greater than 105% of B1
then color A1 red and if A1 is less than 95% of B1 then color A1 green. I can
do the color part but the % put me off.

Thanks,
Jacque

 

[ryguy7272]

1.05 = 105% and .95 = 95%

HTH,
ryan---

 

[David Biddulph]

105%*B1
95%*B1