Forum Discussion
Colour coding for a range of number values in excel.
Hi there.
I am using conditional formatting to try and colour my percent ranges automatically. I am using the "format only cells that contain" option and inputting my percent ranges (for example 1 - 20, 21 - 40 etc...).
It works with every number, apart from if it ends in a zero! So anything that lands on 10, or 50 stays white. Can anyone help or suggest a better way to set this up?
Many thanks,
Chris.
10 Replies
As a quick fix,
i would try 1-9.999 instead of 1-10 times, instead of 1-20 times 1-19.9999, etc. should actually work.
I would be happy to know if I could help with this information.
Nikolino
I know I don't know anything (Socrates)
I've just tried it and it still leaves the whole numbers white.
It's just bizarre why it doesn't include the last number at the end of the range???
- If I may recommend sending the file (without sensitive data), this is the only way to determine with certainty where the error may be. Everything else is more time consuming than necessary.
Thx,
Nikolino
