Hai I am a beginner in excel and is looking for help in copying coloured cells in Excel. I am using conditional formatting (Bold letters with cell background in RED) to identify duplicates in E,F and G coulmns (total columns used in the worksheet is from A to I) respectively in a worksheet with the help of a macro. I need to copy the rows (if any of the cells in E,F & G are in RED colour) to a new worksheet so as to have only duplicate transactions in that page. I dont have any VB expertise and if it has to be coded in VB, can you explain each line (Why is the line required and the impact of the line) so as to hav a better understanding.
Looking for assistance