+ Reply to Thread
Results 1 to 2 of 2

Google sheets - change cell color based on days past date in another cell

  1. #1
    Registered User
    Join Date
    03-09-2021
    Location
    Arizona, United States
    MS-Off Ver
    Google Sheets
    Posts
    1

    Google sheets - change cell color based on days past date in another cell

    When the current date is 60 days past the date in cell D3 I want cell M3 to change red. I want this to happen for each row below it as well. This is in google sheets.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    171

    Re: Google sheets - change cell color based on days past date in another cell

    Hi Coffey80,

    Here's a link to a Google sheet with your requirements: https://docs.google.com/spreadsheets...it?usp=sharing

    Hope this helps.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Google Sheets: Cell changes color based on current time
    By TimRodriguez in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 04-15-2020, 06:48 AM
  2. Looking to display data in a cell, only if today's date is 7 days past a cell's date
    By mbenderpetassure in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2015, 01:57 PM
  3. Replies: 13
    Last Post: 07-09-2014, 04:10 PM
  4. Replies: 2
    Last Post: 12-06-2013, 06:28 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. Replies: 2
    Last Post: 06-18-2013, 01:21 PM
  7. Replies: 5
    Last Post: 12-02-2010, 10:35 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1