Hi,

This is my first time posting on here. I hope I get my question answered.
I have a spreadsheet that has several metrics that measures the success of a project. For each metric, colleagues are to enter the dates that this value would be entered and I would like to create a macro that turns that column red if a value is not entered by that date. For example, I have columns D to G that have dates that certain values are to be entered; D2 could have Nov, 2012 while E2 could have June 2012, I want the cell that has June 2012 to turn red (if no value has been entered) and by December, if no value has been entered in column D, I want that column to turn red (by Value I mean a percentage, like 73%). I hope my question is clear. I am a VBA novice and would appreciate any help I could get