conditional Formatting cell wildcard

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
 
D

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top