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

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

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"ssciarrino" <(E-Mail Removed)> wrote in message
news:4BB555A4-8A83-40D0-9339-(E-Mail Removed)...
>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 thanks for pointing me in the right direction....this works



"Earl Kiosterud" wrote:

> You can use the ISNA() function to test for that.
>
> --
> Earl Kiosterud
> www.smokeylake.com
> -----------------------------------------------------------------------
> "ssciarrino" <(E-Mail Removed)> wrote in message
> news:4BB555A4-8A83-40D0-9339-(E-Mail Removed)...
> >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
>
>
>