conditional Formatting cell wildcard

[RogueIT]

I would like to have conditional formatting added to a cell what is basically
an if then statement

In cell A2: if A2>A3 then (change_red) else (change_green) but when I copy
the formatting to another cell, the cell assignment doesn't change

For example when I copy the formatting of A2 to A14 the logic is
In cell A14: if A2>A3 then (change_red) else (change_green)

What I would like to have happen is, when I copy the formatting to A14 then
the conditional formatting would follow if A14>A15 then (change_red) else
(change_green)

Thanks,
Rogue

 

[David Biddulph]

Make sure that you have A2 and A3, not A$2 and A$3, in your conditions.

I am told that Excel 2007 shows confusing information in CF, so you're
better using 2003.

 

[Sean Timmons]

Remove the $ before the 2 and the 3 before copying and pasting formats.

 

[ryguy7272]

Hello RogueIT! Read this!
http://www.cpearson.com/excel/relative.aspx

HTH,
Ryan--

 

[Gord Dibben]

Takes some getting used to in Excel 2007 David.

If you look at the rule for each cell the A2 does not show as incremented
BUT in actual fact, Excel has incremented internally somewhere so the CF
does work as planned.


Gord