+ Reply to Thread
Results 1 to 2 of 2

Formatting Cells to change colors based on time since being inputted

  1. #1
    Registered User
    Join Date
    10-15-2021
    Location
    Virginia, United States
    MS-Off Ver
    360
    Posts
    1

    Lightbulb Formatting Cells to change colors based on time since being inputted

    Hello all!
    I am trying to figure out how to set up a table so that the rows change colors based on the amount of time since being inputted. So after a row has been populated for more than an hour it changes to yellow, 2 hours it changes to orange, and 3 hours to red. Does anyone have a way to accomplish this without using macros? The sheet is used online and the macros are not compatible with the online functionality it seems. Thank you all for your help!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,989

    Re: Formatting Cells to change colors based on time since being inputted

    Unlikely. You'd need a VBA worksheet Change Event handler to time stamp the entries. Then the CF should be straightforward.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Conditional Formatting using data in Sheet2 to change colors of cells in sheet1
    By vinnievegas in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-02-2020, 02:56 PM
  2. Replies: 0
    Last Post: 06-15-2017, 06:28 PM
  3. [SOLVED] Conditional formatting to change colors of Columns based on data entered in Column E
    By JJFletcher in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-13-2016, 01:27 PM
  4. Replies: 3
    Last Post: 10-21-2015, 03:51 PM
  5. Change multiple cell colors based on date and time passed
    By cvalentine02 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2013, 12:20 PM
  6. [SOLVED] Formatting cells to change color by date (cell value) three diffrent colors???
    By johnoes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2013, 12:12 PM
  7. Replies: 6
    Last Post: 10-05-2012, 05:47 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