You can use conditional formatting to match the colours.



Select the ranges to affect and then go to Home|Conditional Formatting|New Rule

Use the "Format only cells that contain" and enter your lower and upper ranges for each colour.

Hello NBVC,

Thank You. Your instruction worked a charm and I have managed to get the colours working perfectly. I really appreciate your help and time.

Kind regards,


B