I am looking for some help on having a macro do the same job a conditional format would do. So I have two columns F and G that are labeled Last Name then First Name. The conditional format that i have for these to columns work together to detect any two names that are the same and turn or highlight them red. I want to be able to use a macro to perform this function. However I will need this to work on at least 5 sheets or if i and a new sheet, but dont need it to work on the first 3 sheets making it 8 total if that makes sense.