Mar 25 2021 07:28 AM - edited Mar 25 2021 07:28 AM
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.
Mar 25 2021 07:43 AM
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)
Mar 25 2021 08:58 AM
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???
Mar 25 2021 09:46 AM
Mar 25 2021 11:11 AM
Sure. 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.
Mar 25 2021 12:07 PM
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)
Mar 25 2021 12:12 PM
Mar 25 2021 12:23 PM
Mar 25 2021 12:26 PM
Mar 25 2021 12:57 PM