Forum Discussion
Colour coding for a range of number values in excel.
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,
NikolinoSure. Here it is. If you can fix it you would be a life saver! I've written on the sheet which column I would like to colour code.
Thank you.
Please have a look at an example in the inserted file.
There is a mistake in thinking about your file. If it is red up to 20%, why does the next level start at 21%? One percent is missing.
For example, if it is 20.001%, it may not have any color.
Take a look at the example and if you have any questions please feel free to answer.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)