Macro for Conditional formatting controlled by buttons

[Rob.Marchel]

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.

[:) Sixthsense :)]

Try the below code to check cell value and apply the colors to the cells.

Please Login or Register  to view this content.

Try the below code to clear the cell value and reset it to R by applying the default formatting

Please Login or Register  to view this content.

[Rob.Marchel]

Hi Sixthsense!

Fantastic bit of code! The first part works like a charm!

Although the reset function is not exactly, what I'm after.

I need the reset function to remove all colour, yet still maintaining the integrity of the information within AND if possible, changing the cells that are already designated as "R" to say a light grey.

Sorry for the confusion! Love your work so far though!

Rob.

[:) Sixthsense :)]

Try this...

Please Login or Register  to view this content.

[Rob.Marchel]

Doesn't work, however, I've just removed the ".value = "R"" and it resets the range colour. This is actually probably better then what I wanted it to originally do.

I really appreciate the help!

Cheers,

Rob.

[:) Sixthsense :)]

Delete all the CF for that range.

[Rob.Marchel]

How do you mean?

I assumed that by removing .value, it would reset the colour, essentially deleting all the CF applied by the first code?

[:) Sixthsense :)]

For your info I have not used any CF in my code.