Conditional Formating with a formula

[Guest]

I have a cell that has a formula to VLOOKUP another sheet.

I want to conditional format the cell to turn yellow when no value is
returned.

If the VLOOKUP has no value returned on the cell #N/A appears. I tried to
say in the conditional format when cell = #N/A turn yellow but it does not
work I am thinking it doesn't work because of it being a formual and #N/A is
not a true returned value.

Thanks

 

[Earl Kiosterud]

You can use the ISNA() function to test for that.

 

[Guest]

Earl thanks for pointing me in the right direction....this works