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
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