+ Reply to Thread
Results 1 to 4 of 4

color cells containing date based on days passed since today on color scale

  1. 09-07-2022, 08:48 AM #1
    TtNl
    TtNl is offline
    Registered User
    Join Date
    08-23-2022
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    66

    color cells containing date based on days passed since today on color scale

    Trying to color cells from green (today) via white (2 weeks ago) to red (4 weeks ago) via conditional formatting.

    Can't be very hard but my head won't get it today. Thanks for the help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-07-2022, 08:58 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,181

    Re: color cells containing date based on days passed since today on color scale

    Maybe like this.
    Attached Images Attached Images
    Attached Files Attached Files
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 09-07-2022, 09:23 AM #3
    TtNl
    TtNl is offline
    Registered User
    Join Date
    08-23-2022
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    66

    Re: color cells containing date based on days passed since today on color scale

    No idea what I did wrong before but this works, thanks!
    Reply With QuoteRegister To Reply
  4. 09-07-2022, 09:31 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,181

    Re: color cells containing date based on days passed since today on color scale

    Glad to have helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting Color Scale More Than One Rule On Same Cells OR 4-Color Scale
    By joseph707 in forum Excel General
    Replies: 3
    Last Post: 10-18-2020, 09:15 PM
  2. [SOLVED] How to set a cell color, based upon today's date?
    By Mark53 in forum Excel General
    Replies: 8
    Last Post: 07-30-2017, 05:01 PM
  3. [SOLVED] No of Days Passed in current month based on =Today() Function
    By kskhan1105 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-06-2017, 10:16 AM
  4. Conditional Formatting - change color based on how far/close date is from today
    By rosethorn5 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-13-2015, 03:09 AM
  5. I need the color of the cell to change when within 30 days of today's date
    By splate in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2013, 12:53 AM
  6. Change worksheet tab color based on today's date
    By james4026 in forum Excel General
    Replies: 3
    Last Post: 03-31-2010, 06:55 PM
  7. Change row color based on TODAY>=specific date
    By nhentsch in forum Excel General
    Replies: 1
    Last Post: 09-23-2008, 04:12 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1