Conditional formatting
 

to color cell d7

which is your condition to turn d7 as red
1. d7/c7<-20
or
2. (d7-c7)<-20

which is your condition to turn d7 as pink
3. d7/c7-20
or
4. (d7-c7)-20

i am confused, sorry...="if(d7-c7)<-20"

happy holidays...hohoho

"egarcia" wrote:

I want a conditional formula to color cell d7 red if d7/c7 is < -20. Also I
need another formula to color it pink if it is -20. I tried
="if(d7-c7)<-20", but it does not work.