SOLVED
Home

How to use conditional color formatting within another formula.

%3CLINGO-SUB%20id%3D%22lingo-sub-710984%22%20slang%3D%22en-US%22%3EHow%20to%20use%20conditional%20color%20formatting%20within%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-710984%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%20is%20that%20i%20am%20trying%20to%20utilize%20conditional%20color%20formatting%20within%20a%20new%20formula.%26nbsp%3B%20So%20I%20have%20a%20column%20that%20has%20conditional%20formatting%20in%20red%20or%20green%2C%20with%20the%20text%20being%20a%20date.%20To%20make%20the%20next%20formula%20to%20see%20the%20percentage%20of%20green%20cells%2F(green%2Bred%20cells)%20%3D%20should%20give%20me%20compliance.%26nbsp%3B%20Is%20there%20a%20way%20to%20do%20this%20or%20do%20I%20just%20need%20to%20utilize%20the%20original%20formula%20of%20how%20I%20achieved%20the%20conditional%20formatting%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%20Laura.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-710984%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EConditional%20Formatting%3C%2FLINGO-LABEL%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-711068%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20use%20conditional%20color%20formatting%20within%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-711068%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F363848%22%20target%3D%22_blank%22%3E%40AnnaLysta%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20Laura%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFormulas%20work%20with%20values%20only%2C%20you%20shall%20combine%20your%20formulas%20for%20green%2Fred%20and%20apply%20the%20resulting%20formula%20to%20the%20new%20rule.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-711237%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20use%20conditional%20color%20formatting%20within%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-711237%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%20I%20was%20hoping%20there%20was%20some%20way%20to%20do%20this%20but%20like%20you%20didn't%20know%20of%20any%20way%20possible.%20Thank%20you%20for%20confirming%20what%20I%20expected.%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-711437%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20use%20conditional%20color%20formatting%20within%20another%20formula.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-711437%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F363848%22%20target%3D%22_blank%22%3E%40AnnaLysta%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
AnnaLysta
New Contributor

Hi All, 

My question is that i am trying to utilize conditional color formatting within a new formula.  So I have a column that has conditional formatting in red or green, with the text being a date. To make the next formula to see the percentage of green cells/(green+red cells) = should give me compliance.  Is there a way to do this or do I just need to utilize the original formula of how I achieved the conditional formatting?  

 

Thanks! Laura. 

3 Replies
Solution

@AnnaLysta 

 

Hi Laura,

 

Formulas work with values only, you shall combine your formulas for green/red and apply the resulting formula to the new rule.

Thank you! I was hoping there was some way to do this but like you didn't know of any way possible. Thank you for confirming what I expected.  @Sergei Baklan 

Related Conversations