Conditional Formatting Comparison Criterion -- cell above

[Fred Holmes]

Excel 2000 (or a later version if necessary)

I know generally how to do conditional formatting, e.g., with the
compaison of the cell value with an explict (hard coded) number or
string. But how does one make the comparison between the value of the
current cell, and, e.g., the value of the cell immediately above it.
Any attempt I make to put a range address as the test value bombs.

Is there some element of code I'm missing, or does conditional
formatting not do it at all.

TIA.

Fred Holmes

 

[Sheeloo]

If you have to use conditional formatting in cell A2 based on cell A1 then
use the following as the FORMULA IS
=A1>5
or whatever condition you want.

I have used this in 2003 and 2007 versions.

 

[David Biddulph]

Are you sure that you don't mean =A2>A1 rather than =A2:C2>A1:C1 ?
If you copy that across (or select the range A2:C2 before imposing the CF),
then for C2 that will become =C2>C1

 

[David Biddulph]

Select the range and try my formula, Russell.

Glad that some of my responses have been useful. Keep learning!