Jun 20 2019 07:39 AM
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.
Jun 20 2019 08:14 AM
Solution
Hi Laura,
Formulas work with values only, you shall combine your formulas for green/red and apply the resulting formula to the new rule.
Jun 20 2019 09:07 AM
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
Jun 20 2019 10:17 AM
@AnnaLysta , you are welcome
Jun 20 2019 08:14 AM
Solution
Hi Laura,
Formulas work with values only, you shall combine your formulas for green/red and apply the resulting formula to the new rule.