VLOOKUP

J

Jose Aleman

Hi,

I want to do a lookup function but i don't know how to go by it. I have 2
worksheets. I need for Sheet1 to look for some records in Sheet2. If a
record on sheet one finds a matching record on Sheet2, Then the record on
Sheet1 would be colored coded in Red.

I hope I explained this correctly.
 
P

Peo Sjoblom

Use format>conditional formatting>formula is

=COUNTIF(MyRange,B1)>0

where B1 in sheet is the cell you check if it occurs in sheet

you need to name the range you are checking in sheet or else conditional
formatting will not work

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
Top