Is there any way to do a conditional formatting to highlight duplicates based on the second part of a cell? I have a multi column list of patient. They are entered as "Last Name,First Initial Room#" for instance "Smith,J 2317" right now I have to go through our system and manually check if a person has changed rooms. I have to do this for every person. I would like to find a way to have it highlight cells if the number matches. This way if someone comes in and is placed in a room that someone else is still listed in, I know to update that person.