Most valuable professional
  • Hot Topics

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel