Finomad
One other suggestion for you from personal experience:
Reading your list you have said that 0-25 is red and 25-50 is purple etc.
What colour should 25 be?
'Proper' answer
- When you do your conditional formatting you will have to choose either
0-25, 26-50, etc OR 0-24, 25-49 etc (or some other combination that wsuits
you).
- You should consider how many decimal places your data can have. Are you
really saying 0-24.999999999999999 (or 0-25 and 25.000000000000000000001 - 50)
- As you have 4 colours then one will be default. Excel will then process
the others in order. If you set up the rules in the correct order then you
could have 0-25 and 25-50, but you would still have to think carefully and
put them in in the right order.
I'd recommend doing a very quick test spreadsheet for yourself where you
enter some numbers (say 0, 10, 25, 40, 50, 50.5, 60, 75, 90, 100, 100.5, 102,
-26) and then enter your conditional formatting and see what works
M-A