IF column B = anything in column A format

N

Nelson

I have a customer list (!Sheet2 B1 : B100) and I have a result list with
maintenance information and customers names (!Sheet1 B2 :B2000)

The rows and columns on the result list change so the customer name is not
always in the same cell.

I am hoping I can use conditional formatting to say if any customer name
from !Sheet2 B1 : B100 = any customer name in !Sheet1 B1 : B2000 then fill in
cell color and make bold of customer names !Sheet1 B1 : B2000.

Any suggestions?

Thanks in advance
 
M

Max

One way which serves the intended checks (via COUNTIF) and which enables the
CF to work across sheets (via INDIRECT)

In Sheet1, select col B, then apply CF using Formula Is:
=COUNTIF(INDIRECT("'Sheet2'!B:B"),B1)
Format to taste > Ok out

Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top