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]

Select both cells and try these Conditional Formatting formulas:

=$C22>$B22
=$C22=$B22
=$C22<$B22

The $ before the column reference makes it absolute.

 

[luis.carrion]

How can =$C22<$B22 be adjusted that if it says 0 keep it white

 

[luis.carrion]

Thank you. I got it.

 

[luis.carrion]

For some reason they are not working. They dont change color to the color i formated to.

 

[luis.carrion]

This formula is the only one working =$C22<$B22

 

[Andrew Poulsom]

Each formula works for me. Give an example where the other formulas don't work.

 

[satyam263]

Try with the below formulas:

=AND(B22=C22)
=AND(B22>C22)
=AND(C22>B22)

 

[Andrew Poulsom]

Try with the below formulas:

=AND(B22=C22)
=AND(B22>C22)
=AND(C22>B22)

Why would one use AND for a single condition?

 

[luis.carrion]

Andrew Poulsom,

Thank you i was do in it wrong they work perfectly. what about if C22=0 highlight white.

Satyam263 - thank you