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.