? about conditional formatting

  • Thread starter Thread starter JeffP
  • Start date Start date
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
 
One way:

Select the table and enter this as the CF:

Formula is =$A1=$H1

then choose your formatting.
 
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
 
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
 
Hi
just select rows 1 to 15 and enter the formula. The row index will
adapt automatically
 
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
 
Or =$A1<>$H1 for "not equal".

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

Gord Dibben Excel MVP
 
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
 
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.
 
Back
Top