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 ...
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
Thx,
Nikolino
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.
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)
- Hi there.
Thank you for this. I would like to include 20 in the first band, so I'm guessing I should edit the rules to start at 21.001?
Is the correct?
Many thanks.