Conditional formatting with each column to be analyzed individually

Copper Contributor

Dear all,

 

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

econdw1802_0-1626406300271.png

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:

 

econdw1802_1-1626406420252.png

 

Thanks a lot.

 

1 Reply

@econdw1802 

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

NikolinoDE
I know I don't know anything (Socrates)