Forum Discussion
How to use conditional color formatting within another formula.
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.
Hi Laura,
Formulas work with values only, you shall combine your formulas for green/red and apply the resulting formula to the new rule.
3 Replies
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. SergeiBaklan
AnnaLysta , you are welcome
