conditional Formatting cell wildcard

  • Thread starter Thread starter RogueIT
  • Start date Start date
R

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
 
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
 
Back
Top