Excel Learner

Hello.

 

I would like to use a conditional formula for dates, years and months while color assigning it based on what ifs. It is not working.

For example

Here is the original formula

=DATE(YEAR(J16),MONTH(J16)+8,DAY(J16))

I have it set up to turn green if this occurs.

Now if the months are less than 18 months I would like for the cell to turn yellow. How do I do this equation?

By: Vee

14 thoughts on “Excel Learner

  1. ig

    We are a group of volunteers and opening a brand new scheme in our community.
    Your site provided us with useful info to work on. You’ve performed a formidable activity and our whole community might be
    thankful to you.

  2. sling tv best package 2020

    Howdy this is somewhat of off topic but I was wondering if blogs
    use WYSIWYG editors or if you have to manually code with HTML.
    I’m starting a blog soon but have no coding experience so I
    wanted to get advice from someone with experience. Any help would be enormously appreciated!

  3. match.com free trial

    Hi there, There’s no doubt that your website could be having browser compatibility issues.

    Whenever I look at your blog in Safari, it looks fine however, when opening in Internet Explorer, it
    has some overlapping issues. I simply wanted to give you a quick heads up!
    Aside from that, fantastic site!

  4. http://sinnedbeyondhelp.tumblr.com/

    You actually make it seem so easy with your presentation but I find this matter to be actually
    something which I think I would never understand. It seems too complex
    and extremely broad for me. I am looking forward for your next post, I will try to get the hang of it!

  5. ps4 games

    Hi, Neat post. There’s a problem along with your site in internet explorer,
    may test this? IE nonetheless is the marketplace chief
    and a large component of folks will miss your fantastic writing
    due to this problem.

  6. quest bars cheap

    I’m really inspired with your writing abilities as neatly as with the structure on your weblog.
    Is this a paid theme or did you customize it your
    self? Anyway stay up the excellent high quality writing, it is rare to see a great weblog like this one nowadays..

  7. ps4 games

    Wonderful beat ! I wish to apprentice while you amend your site, how could i subscribe for a blog site?

    The account aided me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright clear idea

  8. quest bars cheap

    Hmm it looks like your blog ate my first comment (it was extremely long) so I guess I’ll just sum it up what I wrote and say, I’m thoroughly enjoying your blog.
    I as well am an aspiring blog blogger but I’m
    still new to everything. Do you have any points for rookie blog
    writers? I’d really appreciate it.

  9. quest bars cheap

    you are in reality a good webmaster. The website loading speed is incredible.
    It seems that you are doing any unique trick. Furthermore,
    The contents are masterpiece. you’ve done a magnificent
    task on this subject!

  10. tinyurl.com

    A motivating discussion is definitely worth comment. I believe that
    you should write more about this subject matter, it might not be a taboo subject
    but typically people don’t discuss these subjects. To the next!
    Best wishes!!

Comments are closed.