Prev: Greater Than
Next: Copy specific data form sheets into master sheet
From: RogueIT on 17 Nov 2009 16:16
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
From: Sean Timmons on 17 Nov 2009 16:23
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 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
From: "David Biddulph" groups [at] on 17 Nov 2009 16:17
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" <RogueIT(a)discussions.microsoft.com> wrote in message
news:7C54112F-8D79-453B-BEB0-39744DEBBF7A(a)microsoft.com...
>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


From: ryguy7272 on 17 Nov 2009 16:41
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 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
From: Gord Dibben on 17 Nov 2009 17:11
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.

 | 
Pages: 1
Prev: Greater Than
Next: Copy specific data form sheets into master sheet