Busymanjohn
Member
I have a file which has part numbers in three columns, I need to highlight those parts which appear in more than one column, e.g. a part 1234567 appearing in column A and column B, part 2345678 appearing in column A, B and C.
Highlight cells if data appears in more than one column
- Thread starter Busymanjohn
- Start date
Busymanjohn
Member
Should have said, I can use conditional format to highlight cells that appear in Col A and Col B using the Conditional Format, but need to be able to highlight using 3 columns.
Busymanjohn
Member
It's ok guys ,,, found out what I was doing wrong in my original formula ,,,,, thanks anyway