Change the condition to Formula Is and test the cell against the VLOOKUP
formula so as to return TRue or False, e.g.

=A1=VLOOKUP(A2,$H$1:G$20,2,FALSE)

--

HTH

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

"Frank Haverkamp " wrote in
message ...
How can I base a cells Conditional Formating on the results of a Vlookup
formula?


---
Message posted from http://www.ExcelForum.com/