Conditional formatting columns works incorrectly

[MAKOR]

Hi All,

Can You help me to answer why after setting conditional formatting columns do not respect limits which I have set:

Here is connected another my question for this graph and details how it's build.

[MohammadLoran25 · Accepted solution]

Hi @MAKOR ,

In your conditional formatting enter the related number, not the percent.

For example put 0.8 instead of 80

Then it works as you expect.

If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.

Regards,
Loran