Conditional Formatting not working

Hello

I am using this formula
=vlookup(b1,check,2,false)

I this formula cannot find any information then it displays #N/A

I want all cells that display this to be Highlighted, but conditional
formatting doesn't work

Any other ideas?

Regards

Gaz

--
Message posted via http://www.officekb.com

Gaz

Use conditional formatting select formula is and use the ISNA() function

=ISNA(B1)

and format as necessary

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Crowbar via OfficeKB.com" <u15117@uwe> wrote in message
news:579b589c052bf@uwe...
> Hello
>
> I am using this formula
> =vlookup(b1,check,2,false)
>
> I this formula cannot find any information then it displays #N/A
>
> I want all cells that display this to be Highlighted, but conditional
> formatting doesn't work
>
> Any other ideas?
>
> Regards
>
> Gaz
>
> --
> Message posted via http://www.officekb.com