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 ...
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.
