When you might need to apply color sales Conditional Formatting to multiple rows in Excel using a Macro? We found that is most useful, when you have a perfectly arrange row-by-row conditional formatting, and you are trying to insert a new row. You can try to fix the resulting formatting rules mess manually, or use this macro to set all formats in the range. First you n first row need to select the range were your conditional formatting will apply and clear all formatting rules. Next, you need to setup proper color scale conditional formatting in the first row of the range. Now, you should create a name range to reference…