Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF column B = anything in column A format
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 -- Nelson |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF column B = anything in column A format
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 --- "Nelson" wrote: 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 -- Nelson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format cells in one column based on value in another column | New Users to Excel | |||
Format column to link file names in that column | Excel Discussion (Misc queries) | |||
How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions |