midfieldgeneral11
Active Member
- Joined
- Feb 11, 2004
- Messages
- 464
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
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