software

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.

Use formatgt;conditional formattinggt;formula is

=COUNTIF(MyRange,B1)gt;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

quot;Jose Alemanquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I want to do a lookup function but i don't know how to go by it. I have 2
gt; worksheets. I need for Sheet1 to look for some records in Sheet2. If a
gt; record on sheet one finds a matching record on Sheet2, Then the record on
gt; Sheet1 would be colored coded in Red.
gt;
gt; I hope I explained this correctly.