D divraj New Member May 16, 2014 #1 i have used conditional formatting to color duplicates by selecting alternate cells in a row, but when same is copied to the entire table it is highlighting in a column, how can i achieve this using conditional formatting without using VBA. Attachments condi_forma.jpg 86.5 KB · Views: 6
i have used conditional formatting to color duplicates by selecting alternate cells in a row, but when same is copied to the entire table it is highlighting in a column, how can i achieve this using conditional formatting without using VBA.
D divraj New Member May 16, 2014 #3 Hi Narayan, Please find the sample workbook. Attachments experiment.xlsx experiment.xlsx 8.9 KB · Views: 5
N NARAYANK991 Excel Ninja May 16, 2014 #4 Hi , See your file now. Narayan Attachments experiment.xlsx experiment.xlsx 7.8 KB · Views: 5