Conditional formatting with each column to be analyzed individually

Occasional Visitor

Dear all,


I am preparing a monthly sales report to check the monthly % changes in performance by region:


I use conditional formatting to see the differences in performance each month. 

I hope to see if there is any better way I can have each column to be analyzed individually, as i am preparing the color conditional formatting manually like below:




Thanks a lot.


1 Reply


A file (without sensitive data), Excel version and knowledge of the operating system with a detailed description of your project would be of great advantage for both parties. For you to get a quick and accurate solution proposal and for the helpers to understand quickly and not waste time to help several in this forum.


*Nevertheless, here is a sample file with conditional formatting.

Maybe that's hepls you. 

Thank you for your patience and understanding

I know I don't know anything (Socrates)