Conditional Formatting


Im using dates on my spreadsheet and I want to show a date to be highlighted if its greater than another cell by 18 months, If its less than another cell by 18 months, if it is between 9-12 months of another cell I would like to have it highlighted.

So for example
cell A1= 2/1/2019
cell B1= 7/1/2020

I want cell B1 to be green if it is 18 months or greater than cell A1

I want B1 to be blue if it is between 15-17 months less than cell A1

I want B1 to be yellow if it is 14 months or less than cell A1

Hoping you can help please.
By: Vee

16 thoughts on “Conditional Formatting

  1. quest bars cheap

    I do not even understand how I finished up right here,
    however I assumed this publish used to be
    good. I don’t recognize who you’re but definitely you
    are going to a famous blogger if you aren’t already.


  2. ps4 games

    It is appropriate time to make some plans for the future and it is time to be
    happy. I’ve read this post and if I could I want to suggest you
    some interesting things or advice. Maybe you could write next articles referring to
    this article. I want to read more things about it!

  3. quest bars cheap

    Hi! I’ve been following your website for a long time now and finally got the bravery to go
    ahead and give you a shout out from Lubbock Tx!
    Just wanted to tell you keep up the good job!

  4. quest bars cheap

    Its like you read my mind! You seem to know so much about this, like
    you wrote the book in it or something. I think that you can do with some
    pics to drive the message home a little bit, but other than that,
    this is wonderful blog. A fantastic read. I will certainly be back.

  5. ps4 games

    I’m impressed, I must say. Seldom do I come across a blog that’s equally
    educative and amusing, and let me tell you, you’ve hit the nail on the head.
    The problem is something which too few folks are speaking intelligently about.
    I’m very happy I stumbled across this during my hunt for
    something regarding this.

  6. coconut oil

    We’re a bunch of volunteers and opening a brand new scheme in our community.
    Your website offered us with helpful information to work on. You have performed an impressive activity and our whole
    neighborhood will likely be thankful to you.

  7. sling tv

    Do you have a spam issue on this website; I also am a blogger,
    and I was wondering your situation; many of us have developed some
    nice methods and we are looking to exchange techniques with others, please shoot me an email
    if interested.

  8. sling tv

    Hello, i read your blog occasionally and i own a similar one and i was just
    curious if you get a lot of spam comments? If so how do you prevent it, any plugin or anything you
    can suggest? I get so much lately it’s driving me crazy so
    any support is very much appreciated.

  9. sling tv

    Hey there! I’ve been following your website for some time now and
    finally got the courage to go ahead and give you a shout out
    from Houston Texas! Just wanted to tell you keep
    up the excellent job!

  10. ig

    Having read this I thought it was rather enlightening.
    I appreciate you spending some time and effort to put
    this short article together. I once again find myself spending a significant amount of time both reading and commenting.
    But so what, it was still worthwhile!

Leave a Reply

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