Change color fill in a cell, if another cell contains a date in it
Posted on 2012-09-11
I am trying to find a way that will change the fill in of a cell GREEN if a cell on the same row contains a date in it.
For instance ....
In Column A, there are associated tasks that need to be completed.
In Column H of the same row of that task, when it is completed I enter the date.
What I would like, is that when I enter the date in the cell in Column H of the same row as Column A, the cell in Column A changes to a GREEN Fill IN!.
I found that conditional formatting will only work for a few cells, yet I have over 100 tasks in column a, so a VB Code would be great.