Conditionally formatting a row

  • Thread starter Thread starter markman
  • Start date Start date
M

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)?:(
 
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)
 
Hi Bob
think it's getting late in the UK :-) you probably meant
=NOT(ISERROR(VLOOKUP(A1,lookup_table,2,FALSE)))

best regards
Frank
 
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
 
Back
Top