Learn how to a build a cloud-first strategyRegister Now


Change color fill in a cell, if another cell contains a date in it

Posted on 2012-09-11
Medium Priority
Last Modified: 2012-09-12
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.
Question by:Worldsplayground
  • 2
  • 2
LVL 39

Expert Comment

ID: 38389157
Conditional formatting will work for the whole column if you set it up that way.

How do you have it set up currently?


Author Comment

ID: 38389165
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.
LVL 39

Accepted Solution

nutsch earned 2000 total points
ID: 38389170
select cell A1
select column A
Conditional formatting
New Rule
Use formula (I assume that your cell H is either a date or nothing)
Format to get the green fill-in


Author Closing Comment

ID: 38389902
Absolutely amazing.  Thanks you so much.  It has worked better than I expected.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question