Macro regarding the cell color

Closed
rommy - Feb 1, 2011 at 09:12 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 3, 2011 at 09:31 AM
Hi I would like to have a macro for the following

when i type "red" in a cell the whole cell turns red
when i type "orange" in a cell the whole cell turns orange
when i type "green" in a cell the whole cell turns green
when i type "blue" in a cell the whole cell turns blue
when i type "purple" in a cell the whole cell turns purple
when i type "yellow" in a cell the whole cell turns yellow
when i type "completed" in a cell the whole cell becomes blank
please assist me people

1 reply

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
Feb 3, 2011 at 09:31 AM
Hi Rommy,

Do you have a specific cell or cells in mind like:
A1 or A1:D100 or something like this.
Or do you want this to be applied for the whole sheet?

Reason for asking this is that to search the whole sheet is going to take a while for the macro that I have in mind.

Best regards,
Trowa
0