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

Conditional Formatting not working
 

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
HIS


"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