Conditional Formatting..

[Sergio_Montenegro]

Can you have more than one rule relating to a single cell when using conditional formatting... For example:

Cell C3 = 10
Cell C23 = 12
Cell C33 = 15

What I want to do is change the fill in Cell C3 to a coulorur depeding on it's value against the other 2...

If Cell C3 is lower than both then the fill is green
If Cell C3 is higher than Cell 23 but lower than Cell 33 then the fill is orange
If Cell C3 is higher than both C23 and C33 then the fill is red...

Can this be done (and does it make sense)

Thanks in advance

Serge...

 

[VoG]

Try

If Cell C3 is lower than both then the fill is green
=AND(C3 < C23,C3 < C33)

If Cell C3 is higher than Cell 23 but lower than Cell 33 then the fill is orange
=AND(C3 > C23,C3 < C33)

If Cell C3 is higher than both C23 and C33 then the fill is red...
=AND(C3 > C23,C3 > C33)

 

[Sergio_Montenegro]

Try

If Cell C3 is lower than both then the fill is green
=AND(C3 < C23,C3 < C33)

If Cell C3 is higher than Cell 23 but lower than Cell 33 then the fill is orange
=AND(C3 > C23,C3 < C33)

If Cell C3 is higher than both C23 and C33 then the fill is red...
=AND(C3 > C23,C3 > C33)

VoG, thanks very, very much that works a treat....

Cheers

Serge