Condtional Formatting

[luis.carrion]

Good Evening,

I need a formmating or formula that:

if Column C22 is greader than B22 highlight in RED Column B22:C22

if Column C22 is equals to B22 highlight in GREEN Column B22:C22

if Column C22 is smaller than B22 highlight in YELLOW Column B22:C22

 

[Andrew Poulsom]

If you want a new Conditional Format use:

=$C22=0

and position it first in the list. To use the existing Conditional Formats and have no formatting if C22=0 amend the formulas to:

=$C22*($C22>$B22)
=$C22*($C22=$B22)
=$C22*($C22<$B22)

 

[luis.carrion]

Column B22 is in yellow because because i put the formula =$C22<$B22 so anything less than the number highlights in yellow but i need a formula that if C22 is 0 B22:C22 hightlight in white.

sorry

 

[Andrew Poulsom]

Did you try what I suggested?

 

[luis.carrion]

I gues i was doing something wront. I did it again and it works using your formula.

Thank you