Excel: excel VBA if background color then


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


This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of December 11, 2014.


For more resources for Microsoft Excel