Forum Discussion
empeters27
Dec 05, 2023Copper Contributor
conditional formatting based of percent of another cell?
I am trying to set up formatting based on the percent of another cell. I've attached a screenshot to provide context. I have manually color coded these but I would like it to be automatic as follows...
HansVogelaar
Dec 05, 2023MVP
You may want to add one more rule, with 'equal to', ="NA" and No Color.