Results 1 to 5 of 5

Thread: Cell color change based on date.

  1. #1
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    41
    Articles
    0
    Excel Version
    1901

    Cell color change based on date.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello Guru's,

    I need a formula that will change the color of a cell based on a date and not change once the date has moved on. Conditional formatting will do this but limited to one month out. I need it to make a color change (red) based on 1 month and (yellow) three months out. See attached for what I would like it to look like.

    Kind Regards - Bob
    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,682
    Articles
    0
    Excel Version
    O365
    Use formulas rather than those presets, such as

    1 month - =AND($H3>EOMONTH(TODAY(),0),$H3<=EOMONTH(TODAY(),1))
    3 months - =AND($H3>EOMONTH(TODAY(),2),$H3<=EOMONTH(TODAY(),3))

    etc.

  3. #3
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    41
    Articles
    0
    Excel Version
    1901
    Bob, thanks for the quick reply, Am I able to set multiple formulas in styles under conditioning?

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,682
    Articles
    0
    Excel Version
    O365
    Yes, you can have lots. I am not sure what the limit is, but I am sure that it is far more than you will ever need.

  5. #5
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    41
    Articles
    0
    Excel Version
    1901
    Hey thanks, I figured it out and it does exactly what I need!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •