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

Posted on 2012-09-11
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
    LVL 39

    Expert Comment

    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

    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

    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

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

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now