Conditional format question

[Paul Hyett]

Excel 2003

Is there a way of comparing the value in the current cell, against that
of the rightmost occupied cell in a row range?

 

[Don Guillett]

formula is and format as desired. Assumes numbers

=b2=INDEX($2:$2,MATCH(9999999,$2:$2))

 

[Paul Hyett]

formula is and format as desired. Assumes numbers

=b2=INDEX($2:$2,MATCH(9999999,$2:$2))

Thanks - I'll give that a try!

 

[Paul Hyett]

formula is and format as desired. Assumes numbers

=b2=INDEX($2:$2,MATCH(9999999,$2:$2))

OK, I've entered it as follows, in a4, with the numbers to test in row 4
in the range of columns as below...

=A4=INDEX($J:$BI,MATCH(9999999,$J:$BI))

But it doesn't work...

 

[Dave Peterson]

You didn't include the row (4) in both of your range addresses.

 

[Paul Hyett]

You didn't include the row (4) in both of your range addresses.

So it should have been : =A4=INDEX($J4:$BI4,MATCH(9999999,$J4:$BI4)),
then?

 

[Paul Hyett]

So it should have been : =A4=INDEX($J4:$BI4,MATCH(9999999,$J4:$BI4)),
then?

I've changed it to =A4<>INDEX($J4:$BI4,MATCH(9999999,$J4:$BI4)) and now
it seems to have the desired effect - thanks.