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

In cell A2: if A2A3 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 A2A3 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 A14A15 then (change_red) else
(change_green)

Thanks,
Rogue

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.
--
David Biddulph

"RogueIT" wrote in message
...
I would like to have conditional formatting added to a cell what is
basically
an if then statement

In cell A2: if A2A3 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 A2A3 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 A14A15 then (change_red) else
(change_green)

Thanks,
Rogue

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

"RogueIT" wrote:

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

In cell A2: if A2A3 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 A2A3 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 A14A15 then (change_red) else
(change_green)

Thanks,
Rogue

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

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Sean Timmons" wrote:

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

"RogueIT" wrote:

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

In cell A2: if A2A3 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 A2A3 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 A14A15 then (change_red) else
(change_green)

Thanks,
Rogue

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

On Tue, 17 Nov 2009 21:17:35 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

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.