Conditional formatting with each column to be analyzed individually

%3CLINGO-SUB%20id%3D%22lingo-sub-2554737%22%20slang%3D%22en-US%22%3EConditional%20formatting%20with%20each%20column%20to%20be%20analyzed%20individually%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2554737%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20preparing%20a%20monthly%20sales%20report%20to%20check%20the%20monthly%20%25%20changes%20in%20performance%20by%20region%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22econdw1802_0-1626406300271.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296277iB879550B85B6C7CF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22econdw1802_0-1626406300271.png%22%20alt%3D%22econdw1802_0-1626406300271.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20use%20conditional%20formatting%20to%20see%20the%20differences%20in%20performance%20each%20month.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20to%20see%20if%20there%20is%20any%20better%20way%20I%20can%20have%26nbsp%3Beach%20column%20to%20be%20analyzed%20individually%2C%20as%20i%20am%20preparing%20the%20color%26nbsp%3Bconditional%20formatting%20manually%20like%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22econdw1802_1-1626406420252.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296278iEDD0989E733618C9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22econdw1802_1-1626406420252.png%22%20alt%3D%22econdw1802_1-1626406420252.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2554737%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2555337%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20with%20each%20column%20to%20be%20analyzed%20individually%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2555337%22%20slang%3D%22en-US%22%3EA%20file%20(without%20sensitive%20data)%2C%20Excel%20version%20and%20knowledge%20of%20the%20operating%20system%20with%20a%20detailed%20description%20of%20your%20project%20would%20be%20of%20great%20advantage%20for%20both%20parties.%20For%20you%20to%20get%20a%20quick%20and%20accurate%20solution%20proposal%20and%20for%20the%20helpers%20to%20understand%20quickly%20and%20not%20waste%20time%20to%20help%20several%20in%20this%20forum.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20patience%20and%20understanding%3CBR%20%2F%3E%3CBR%20%2F%3ENikolinoDE%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2555670%22%20slang%3D%22de-DE%22%3ERe%3A%20Conditional%20formatting%20with%20each%20column%20to%20be%20analyzed%20individually%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2555670%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1104952%22%20target%3D%22_blank%22%3E%40econdw1802%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20file%20(without%20sensitive%20data)%2C%20Excel%20version%20and%20knowledge%20of%20the%20operating%20system%20with%20a%20detailed%20description%20of%20your%20project%20would%20be%20of%20great%20advantage%20for%20both%20parties.%20For%20you%20to%20get%20a%20quick%20and%20accurate%20solution%20proposal%20and%20for%20the%20helpers%20to%20understand%20quickly%20and%20not%20waste%20time%20to%20help%20several%20in%20this%20forum.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENevertheless%2C%20here%20is%20a%20sample%20file%20with%20conditional%20formatting.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EMaybe%20that's%20hepls%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThank%20you%20for%20your%20patience%20and%20understanding%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20NikolinoDE%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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)