Hello All (Using Excel 2007)
In column A I have list of cells that I want to CF. (A2:A5000)
Example of cell entries....
2468-WST-HEN-HTG-BI032
2468-GSV-BLD-ADM-EC016S
2468-GSV-BLD-EFC-EC052S
2468-GSV-QSJ-L01-BI032
2468-QSE-MAN-17B-EC506E
2468-QSJ-MAN-12F-EC760J
2468-QSH-FIN-26F-WS011
2468-WST-PCK-26D-CR024
2468-QSH-PCK-26A-FC144
2468-WHP-MAN-L02-SC047
2468-QSH-PCK-MBP-WP109
2468-QSH-FIN-26F-CR024
I want to conditional format if...... =MID(A2,18,7) is = to another cell up to cell A5000 and the same for any of the other cells in that range.
Thank You
In column A I have list of cells that I want to CF. (A2:A5000)
Example of cell entries....
2468-WST-HEN-HTG-BI032
2468-GSV-BLD-ADM-EC016S
2468-GSV-BLD-EFC-EC052S
2468-GSV-QSJ-L01-BI032
2468-QSE-MAN-17B-EC506E
2468-QSJ-MAN-12F-EC760J
2468-QSH-FIN-26F-WS011
2468-WST-PCK-26D-CR024
2468-QSH-PCK-26A-FC144
2468-WHP-MAN-L02-SC047
2468-QSH-PCK-MBP-WP109
2468-QSH-FIN-26F-CR024
I want to conditional format if...... =MID(A2,18,7) is = to another cell up to cell A5000 and the same for any of the other cells in that range.
Thank You