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

Capturing Formatting with VLookup	1	Feb 25, 2010
vlookup question - bring in all values?	6	Nov 3, 2009
VLOOKUP Problem	1	Dec 10, 2009
Formatting Data in cell in colour	3	Jan 28, 2008
Sum Vlookup where there are blanks	1	May 10, 2010
Combo Box - How to Use Output in Vlookup	4	Jul 5, 2009
VLOOKUP	2	May 29, 2017
Can't Explain N/A in Vlookup	2	Oct 16, 2014

Ask a Question