? about conditional formatting

J

JeffP

Hi,

I have a table and i would like to color the row if cell a(current row) does
not equal cell h(current row).
Is this possible?
I cant figure out how to specify "current row" in the formula

Thanks,
JeffP
 
J

JE McGimpsey

One way:

Select the table and enter this as the CF:

Formula is =$A1=$H1

then choose your formatting.
 
F

Frank Kabel

Hi
try the following:
- select your row (lets assume it is row 1)
- goto 'Format - Conditional Format'
- enter the formula:
=$A1<>$H1
- choose your format
 
J

JeffP

The problem with this solution is that the 1 does not increment thus for
row15 the formula is still $A1=$H1, there must be a way to have this value
increment?


JeffP
 
F

Frank Kabel

Hi
just select rows 1 to 15 and enter the formula. The row index will
adapt automatically
 
J

JeffP

thanks,
I thought i had tried that and couldnt get it to work but i just retried it
and you are correct it is working..

thanks,
JeffP
 
G

Gord Dibben

Or =$A1<>$H1 for "not equal".

Make sure you select the row headers before entering the CF formula.

Gord Dibben Excel MVP
 
J

JeffP

Just out of curiosity, if i have more than one condition are they and'ed or
or'ed
there is no option in the dialog and no mention in the help.

tks
JeffP
 
D

Dave Peterson

Did you mean if you had more than one conditional formatting condition--not a
compound "if" statement in one condition?

If yes, then they're not and'ed or or'ed. The highest one to satisfy its
condition wins--and the testing doesn't go any further.

Cond 1:
=a1>0
cond 2:
=a1>5
cond 3:
=a1>10

I'll only get that first formatting if I enter any positive value.
 
Top