VBA code assistance - adding interior cell background color to weekly report

[bootj1234]

The following image shows a report I produce on a weekly basis that I would appreciate assistance in creating VBA code to automate adding in the various cell interior background colors. It’s important to note that I would like the finished code to treat the cell range as dynamic since the number of rows within the report can change from week to week.

I am not sure, but I believe that using the identification of key words and numbers could aid in getting code to recognize where various interior cell background colors get applied; that is:

1. The words (ADD, REMOVE, KEEP – Paid Advertisers) in column A would call out which rows would have RGB(128, 128, 128) applied as the interior cell background color.

1. The number 0.5 located in column D cells would call out which cells would have RGB(255, 230, 153) applied as the interior cell background color.

1. The column header word “Rotation” in column E would call out that the background color RGB(248, 203, 173) to be applied as the interior cell background color to those cells that have no color applied to them.

1. The column header “Airtime Start Date” in column J would call out and apply the background color RGB(180, 198, 231) within cells in-between rows “ADD” and “REMOVE” that have a date in them. If there is no date in the cell, then no color would be applied to the cell interior.

1. The column header “Airtime End Date” in column K would call out and apply the background color RGB(180, 198, 231) within cells in-between rows “REMOVE” and “KEEP – Paid Advertisers” that have a date in them. If there is no date in the cell, then no color would be applied to the cell interior.

Thank you for your consideration and support in providing me with the code that will allow the accomplishment of my report automation goal.

[/IMG]