I'm trying to define some simple conditional formatting rules based on the value of different percentages. You can see that I have a table called attendance here:

And some cells below it. The cells below the table show the conditional formatting rules I'd like to apply to the table. In fact, the same conditional formatting rules are actually also applied to the column in the table. However, the results are inconsistent, and the table cells aren't displaying at the correct min, mid, and max colors I wanted.

You can see I confirm these settings here:

I also took a screenshot showing the complicated formula used to calculate the percentage. Does this have something to do with not making the conditional formatting work?

Any help would be greatly appreciated!

CodePudding user response：

If you want to make sure that a cell with a value of 0% is colored in red, 50% in yellow and 100% in green, try this: