SOLVED

How to use conditional color formatting within another formula.

Copper 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
best response confirmed by AnnaLysta (Copper Contributor)
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 

1 best response

Accepted Solutions
best response confirmed by AnnaLysta (Copper Contributor)
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.

View solution in original post