Conditionals

Hi Antony

It's not possible to do this using colour scales, but you can use the first option under the conditional formatting menu, Highlight Cell Rules, to layer as many different colours as you like.

For example:

Format cells that are greater than 750 with green fill.
Format cells that are greater than 500 with yellow fill.
Format cells that are greater than 250 with amber fill.
Format cells that are greater than 0 with red fill.

This would give four distinct colours based on your number criteria.

Let me know if you have any problems with this.

Kind Regards,

Sarah Reid
Excel Trainer