Conditionally formatting a row

[markman]

I'd like to test a value in a row based on a lookup table, and if the
value test positive, hi-lite the row in a specifc color. Short of doing
this in VBA, does anyone know of a way using standard Excel functions
(or combinations thereof)?

 

[Bob Phillips]

If I understand, something like this formula in conditional formatting

=NOT(ISERROR(A1,lookup_table,2,FALSE))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi Bob
think it's getting late in the UK you probably meant
=NOT(ISERROR(VLOOKUP(A1,lookup_table,2,FALSE)))

best regards
Frank

 

[Bob Phillips]

Spot-on, bed-time. I just answered a direct email from a guy that had
Lookups all over it, I got VLOOKUP-blinded<G>

See you tomorrow.

Bob