Vlookup and formatting

Prixton · Apr 25, 2008

Hi,
In Excel 2003, is it possible to combine VLOOKUP and formatting so when
there is no match the cell is red?
Thanks in advance.

Gord Dibben · Apr 25, 2008

Format>CF>Formula is: =ISNA(cellref)

Gord Dibben MS Excel MVP

Prixton · Apr 25, 2008

Thanks a lot!!

Gord Dibben said:
Format>CF>Formula is: =ISNA(cellref)

Gord Dibben MS Excel MVP