Keep colors even after removing Conditional Formatting in Excel

The video offers a short tutorial on how to keep colors even after removing Conditional Formatting in Excel.

[chillstress]

you solved a great puzzle my friend! Thank you so much for sharing! 💯👍

[claudiacastro]

It worked only once in a sheet, now i can only apply this by cells and my report is huge. Help!!!!

[christopherwhite]

Great thanks, although I used this on two separate worksheets and only worked for one. First one worked fine, and second, with the exact same formatting, etc, was not having it!