Conditional format question

  • Thread starter Thread starter Paul Hyett
  • Start date Start date
P

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?
 
formula is and format as desired. Assumes numbers

=b2=INDEX($2:$2,MATCH(9999999,$2:$2))
 
formula is and format as desired. Assumes numbers

=b2=INDEX($2:$2,MATCH(9999999,$2:$2))
Click to expand...
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...
 
So it should have been : =A4=INDEX($J4:$BI4,MATCH(9999999,$J4:$BI4)),
then?
Click to expand...

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