Conditional formatting


I want to highlight whether my “Next Due Date” is in the past or the future , ie. to highlight when the item is overdue. I want the month of my “Next Due Date” to be either red (indicates “Next Due Date” has passed) or green (indicates “Next Due Date” is in the future). See data below:

BRISBANE – Work Health and Safety  Date of last completion Required every # months Next due date Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Policy Review
OH&S Policy Branch & Service Manager to read policy and be aware of responsibilities.  14-Nov-17 12 14-Nov-18                     0  

I currently have the month of the “Next Due Date” highlighting either red or green. I also want the month to be highlighted red if the year is in the past, or highlighted green if the year is in the future.




By: Andrew

17 thoughts on “Conditional formatting

  1. coconut oil of

    My coder is trying to convince me to move to .net from PHP.
    I have always disliked the idea because of the expenses.
    But he’s tryiong none the less. I’ve been using WordPress on a variety of websites for about a
    year and am nervous about switching to another platform.
    I have heard great things about
    Is there a way I can transfer all my wordpress content into it?
    Any help would be greatly appreciated!

  2. ps4 games

    This is very interesting, You’re a very skilled blogger.

    I have joined your rss feed and look forward to seeking more of your wonderful post.
    Also, I’ve shared your website in my social networks!

  3. quest bars cheap

    Hey There. I found your weblog using msn. This is a
    really well written article. I’ll be sure to
    bookmark it and return to read extra of your helpful information. Thank you
    for the post. I’ll certainly return.

  4. ps4 games

    Excellent way of describing, and good paragraph to take data concerning my presentation subject matter, which i
    am going to deliver in university.

  5. coconut oil

    My brother recommended I might like this web site.
    He was entirely right. This post truly made my day. You
    cann’t imagine just how much time I had spent for this info!

  6. coconut oil

    Undeniably believe that which you said. Your favorite reason seemed
    to be on the net the easiest thing to be aware
    of. I say to you, I certainly get irked while people think about worries that they just don’t
    know about. You managed to hit the nail upon the top and defined out the whole thing without having
    side effect , people can take a signal. Will likely be back to get more.


    Oh my goodness! Incredible article dude! Thank
    you, However I am having difficulties with your RSS.
    I don’t understand why I can’t subscribe to
    it. Is there anybody else having the same RSS issues? Anyone that knows the answer will you kindly respond?

  8. sling tv

    I got this web site from my pal who informed me regarding this web
    page and at the moment this time I am visiting this site and reading very informative posts

  9. sling tv

    Hola! I’ve been reading your site for a while now and finally got the courage
    to go ahead and give you a shout out from New Caney Texas!
    Just wanted to mention keep up the good work!

Leave a Reply

Your email address will not be published. Required fields are marked *