Change color fill in a cell, if another cell contains a date in it
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.
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.
ASKER
What I found was that the conditional formatting would not look at each individual cell. So if I added a date in Column H, the whole of Column A would go green.
I could possibly be using the wrong conditional formatting option.
Could you possibly give me a step by step approach as to which conditional formatting I should use and if so, what formula I should enter. Then I can compare and make the right changes.
I could possibly be using the wrong conditional formatting option.
Could you possibly give me a step by step approach as to which conditional formatting I should use and if so, what formula I should enter. Then I can compare and make the right changes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Absolutely amazing. Thanks you so much. It has worked better than I expected.
How do you have it set up currently?
Thomas