This is a discussion on Recording a Macro for conditional formatting in Excel 2010 within the Excel Questions forums, part of the Question Forums category; Hi folks, I have an existing macro that I wrote in Excel 2003, that contains various lines of code for ...
Hi folks, I have an existing macro that I wrote in Excel 2003, that contains various lines of code for conditional formating of cells within a worksheet. I have switched over to Excel 2010 (required by our company), and the macro runs fine, but some of the conditional formatting is not working as before. I went in to record a macro to "tweak" the code to correct the mis-match, and when I was finished, I had hundreds of lines of code for conditional formatting that had nothing to do with the cell that I was formatting in the record mode. It looks like it recorded code for every cell in the sheet that had conditional formatting already applied to it.
Can anyone explain why this happens? Should I re-do all of my conditional formatting code that I created in Excel 2003, as it appears the way 2010 handles conditional formatting is much different than the '03 version?