Hi,

What I'm after is a code that does the following.

On press:

Range(H6:AK205)

Cells with the value "C" turn green
Cells with the value "X" turn orange
Cells with the value "Y" turn Yellow

Then another button to clear all and apply grey to cells with a value "R".

Can anyone point me in the right direction?

Thanks in advance!

Rob.