Conditional Formatting Based on Cell Values

[SalientAnimal]

Hi All,

This is probably a pretty basic question, but for the life of me I can not remember how to correctly apply Conditional Formatting to a range of cells instead of applying it to each cell one at a time.

I would like to apply conditional formatting to a number of cells based on a corresponding cell. i.e.

If Cell A1 > B1 then Format Green, If Cell A1 < B1 then Format Red
If Cell A2 > B2 then Format Green, If Cell A2 < B2 then Format Red

I know I can do this by applying it to each cell one at a time, but this is quite time consuming over a large range of cells.

Your help here is greatly appreciated, thanks.

[TMS]

Select the whole range and use the formula for the first row. Make sure the row number is relative not absolute.

[SalientAnimal]

Thanks for the quick reply...

Please let me know what I am doing wrong here? The value is being checked against J4 and not the value cell that is related to it.



Conditional.jpg

Thanks

[TMS]

What have column H and cell J4 got to do with A1, A2, B1, B2, etc?

In answer to that original question, you would select cells A1:An, where n is the last row of data. The formula would be

Please Login or Register  to view this content.

for green and a separate formula

Please Login or Register  to view this content.

for red.

[SalientAnimal]

Apologies, I only used A & B as examples for purposes of the question.
H & J are the actual columns I am working with. Will apply the solution provided and check it again.
Thanks

[SalientAnimal]

HI there,

I tried the suggested, but I still don't get the desired result. I have only applied one formula thus far to check. See attached example

Conditional2.jpg

[TMS]

Remove the quotes from the formula.

[SalientAnimal]

Perfect, thanks a million. I think I kept making the same error in my formula which is why I couldn't get it to work.

[TMS]

You're welcome. Thanks for the rep. And thanks for the feedback.

Easy mistake to make. It often puts quotes in for less than obvious reasons and then you see what you expect to see.