Check Background color of cell and write appropriate value in adjacent cell

[AnirudhC]

Hi all,

So, I want the macro to check the background color in Column A jump to the next cell in Column B and write whatever Value is assigned to it..
so if the background color is yellow i want the next column to say "Bi-monthly" etc.
You can find the other colors and their value in the top part of the attached file

I have tried my level best but I don't have exact color.index value for most of the colors so I was trying to use RGB as a reference but failing at that too..

here is the code so far:

Please Login or Register  to view this content.

[AnirudhC]

I know the color indexes are wrong after Bi-monthly... I couldn't find the exact color indexes for the color that I want them to be...

[Sintek]

Put this code in your sheet object and when you click on the cell it will display the color index to be used for your code.

Please Login or Register  to view this content.

[AnirudhC]

Put this code in your sheet object

Ok I'm going to sound like a complete noob, but how to do this? lol

[AnirudhC]

nevermind figured it out!

[Sintek]

K, not to worry...Have a look at this code and attached workbook....Push [Execute] Button

Please Login or Register  to view this content.