Conditional Formattting

[midfieldgeneral11]

Good Morning

Can you help?

I have a conditional formatting with three rules.

Looks into a column which has as formulae which states column c which states 100%, 50% or 33%

I have placed the rules of 1 which is green (100%) 0.5 which is yellow (50%) and for the 33% is RED.

But the 33% does not work......33.3333333 does not work how do I get this to work?

What is the number?

Can you help?

Regards

Simon

 

[Kelbo]

I assume that the value of 33% is actually referring to one third (1/3) which as a percentage is 33.333333....%.


I suggest using 1/3 as the value not 33%.

Kelbo