How can I base a cells Conditional Formating on the results of a Vlookup formula?
F Frank Haverkamp Jan 11, 2004 #1 How can I base a cells Conditional Formating on the results of a Vlookup formula?
B Bob Phillips Jan 11, 2004 #2 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)
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)
