excel VBA if background color then

[Ferlucia]

Hello everyone,

I'm trying to create a VBA code that works with background color and does:

IF all filled cells in a row (starting from column F) have a green background then the correspondig cell in D gets a green backgroud.
IF 1 or more (but not all) filled cells in a row (starting from column F) have a green background then the corresponding cell in D gets a yellow background.
IF none of the filled cells in a row (starting from column F) have a green background then the corresponding cell in D stays white.

The amount of filled cells per row is VARIABLE
This code should only start from row 4 and down

Hope you can help

 

[Rick Rothstein]

It still doesn't work...

Maybe I'm doing something wrong?

I tried connecting it to a button, but for some reason I can't add any buttons...

Some questions...

1) What kind of button did you try to add... a Forms button or an ActiveX button?

2) Where did you install the code (did you see JoeMo's installation note in Message #9)?

3) Are you sure the color numbers you posted in Message #7 are correct? Select one of your green cells and then execute this statement in the VBA Immediate Window and tell us the number that gets printed out...

? Selection.Interior.Color

 

[JoeMo]

It still doesn't work...

Maybe I'm doing something wrong?

I tried connecting it to a button, but for some reason I can't add any buttons...

That's a different problem if you're using an active-x button. See here for a fix: http://www.mrexcel.com/forum/excel-questions/823352-activex-buttons-stoped-working.html

 

[Ferlucia]

I followed the steps from JoeMo's post and it works

I'm still new at this and sometimes I forget the most obvious things

So thank you Rick Rothstein for your code
And thanks JoeMo for your step by step explanation

Thanks for your time and help