Conditional Format 2007

P

Paula

I have 2 columns of numbers. If the number in column 2 is > adjacent number
in row 1, then red: if < black, if = then blue. I know how to do this for
each individual row by using the CF, but how can I avoid writing this over
and over again for each row? I thin I need to use a formula, but cannot
figure it out. Thanks.
 
D

David Biddulph

Turn the absolute references to relative references for the rows in your CF
formula. (Delete the $ sign preceding the row reference, so change A$2 to
A2.)
 

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