hi I am having a problem with conditional formatting.
On the attached worksheet what I am looking for is to use a 3 way conditional colour format.
if cell A2 is less than B2 then I want the cell to go green
if cell A2 is more than B2 then I want the cell to go red
if cell A2 is = to B2 then I want the cell to go amber(yellow)
I can do this quite easily however when I want to drag the conditional format all the way down Column A it takes on the values that relate to the first cell conditional formatting so will not format to their equivalent cell. So using the 3 conditions I want
A3 to relate to B3
A4 to B4
A5 to B5
and so on.
I tried to use format painter but it still goes back to the values of row 2 and not its row that it is in.
Apologies if thats not clear.
Conditional Formatting
On the attached worksheet what I am looking for is to use a 3 way conditional colour format.
if cell A2 is less than B2 then I want the cell to go green
if cell A2 is more than B2 then I want the cell to go red
if cell A2 is = to B2 then I want the cell to go amber(yellow)
I can do this quite easily however when I want to drag the conditional format all the way down Column A it takes on the values that relate to the first cell conditional formatting so will not format to their equivalent cell. So using the 3 conditions I want
A3 to relate to B3
A4 to B4
A5 to B5
and so on.
I tried to use format painter but it still goes back to the values of row 2 and not its row that it is in.
Apologies if thats not clear.
Conditional Formatting
