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 would like to include 20 in the first band, so I'm guessing I should edit the rules to start at 21.001?
then 1) 0%-20,9999% / 2) 21%-39,9999% / 3) 40% - 59,9999% / 4) 60% - 79,9999% / 5) 80% - 100%
That would be what you want it to be.
then 1) 0%-20,9999% / 2) 21%-39,9999% / 3) 40% - 59,9999% / 4) 60% - 79,9999% / 5) 80% - 100%
That would be what you want it to be.
Yes! 🙂
Amazing. Thank you so much.
I'm not mathematically coherent anyway, let alone putting it into excel.
Amazing. Thank you so much.
I'm not mathematically coherent anyway, let alone putting it into excel.
- Ok...so now a new problem.
I had set the numbers to round up to the nearest whole number, so now the colours are in accurate if it is say 61, or 81 because the number might actually be 60.6 but it is rounding it up.
Is there anyway of the conditional formatting to read the actual number in the cell, (rounded up version) rather than the raw unrounded number, as I think it is reading the decimal points.
I hope that makes sense?
Chris. - your welcome