Formula
 

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

Formula
 

1.05 = 105% and .95 = 95%

HTH,
ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jacque" wrote:

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

Formula
 

105%*B1
95%*B1
--
David Biddulph

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