Change Font Colour If Cell Less Than Another Cell

[FatalLordes]

Hi All. How do I use conditional formatting to say look at the value in cell B18 and if it is less than the value in B10, turn the font colour red. I want to compare B18 to B24 and do that, always comparing to B10. I will eventually want to do exactly the same again but changing B for C. How do I do that. I had a go and B18 changed to red, which is should, but none of the others did even though I highlighted those cells when I created the conditional formula so I obviously did it wrong. Help!

 

[SanjayGMusafir]

If you want Cells B18:B24 to be highlighted if less than B10 then

Choose cells B18:B24
Use formula for conditional formatting

=B18<B$10

Using Dollar sign is important as it makes Cell B10 static in one direction (downward) but you can use same rule in other columns like C as B is not static only row 10 is static.

If you want to compare with B10 only no matter which column it is then use -

=B18<$B$10

Hope it helps

 

[FatalLordes]

If you want Cells B18:B24 to be highlighted if less than B10 then

Choose cells B18:B24
Use formula for conditional formatting

=B18<B$10

Using Dollar sign is important as it makes Cell B10 static in one direction (downward) but you can use same rule in other columns like C as B is not static only row 10 is static.

If you want to compare with B10 only no matter which column it is then use -

=B18<$B$10

Hope it helps

Vunderbah! Thank you so much! That worked. So it I want to do the same for column C or more, I would actually need to create a new CF rule, correct? Or is there some way to say span that same rule across multiple columns. This is what the rule looks like presently:

 

[SanjayGMusafir]

So it I want to do the same for column C or more, I would actually need to create a new CF rule, correct?

No Just modify range where it applies to. Simple