i am using a macro in excel to sort data that is being imported from csv i am wondering can i add on to the macro to conditional format each row to a shade if they are grouped together by the same data in a column example column A will have a full name of a person and I would like it to format it in a grey shade and once a new name comes up leave it white and then when the next name go back to grey or if needed another shade
Solved by Z. H. in 26 mins