ExcelBanter - Vlookup and formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Vlookup and formatting (https://www.excelbanter.com/excel-discussion-misc-queries/185116-vlookup-formatting.html)

Prixton

Vlookup and formatting

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

Vlookup and formatting

FormatCFFormula is: =ISNA(cellref)

Gord Dibben MS Excel MVP

On Fri, 25 Apr 2008 17:46:45 +0200, "Prixton" wrote:

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.

Prixton

Thanks!!

Thanks a lot!!

"Gord Dibben" <gorddibbATshawDOTca skrev i meddelandet
...
FormatCFFormula is: =ISNA(cellref)

Gord Dibben MS Excel MVP

On Fri, 25 Apr 2008 17:46:45 +0200, "Prixton"
wrote:

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.

All times are GMT +1. The time now is 12:41 PM.