If you mean a functionality that can set conditional color based on specific values, for example, if percentage>80%, color the cell to green, if percentage<50%, color the cell to red, otherwise, set to yellow. Unfortunately, this is not achieveable. Currently, conditional formatting only supports to specify the Minimum and Maximum as Numbers.
Someone has submitted a similar feature request here, you could click to vote it up.
Best regards, Yuliana Gu
Community Support Team _ Yuliana Gu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.