+ Reply to Thread
Results 1 to 2 of 2

Cell value/color change basis time

  1. #1
    Registered User
    Join Date
    05-05-2021
    Location
    India
    MS-Off Ver
    16
    Posts
    3

    Cell value/color change basis time

    Hi

    I am working on something like a availability tracker where I want a cell to go green or change its value to Available between a specified time say 10 to 7 after which I want to again go back to normal / Offline till the next day until it strikes 10 again.

    Any leads would be appreciated.

    Thanks much

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,714

    Re: Cell value/color change basis time

    One way to achieve this is to create an ontime schedule event. In a standard module, Use the code below:

    Please Login or Register  to view this content.
    You can then add the following to the workbook module for the code to start and end with opening and closing the workbook.

    Please Login or Register  to view this content.
    Example file attached.
    Attached Files Attached Files

+ 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. Change cell color if time has not changed
    By JOMATT in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2020, 11:46 AM
  2. [SOLVED] Cell color change base off of date and time
    By greenishsheep in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-09-2017, 02:26 PM
  3. [SOLVED] Excel VBA change cell color if time is between
    By hackini in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-14-2016, 12:51 PM
  4. Cell Color Change after time passes from a certain date
    By Ruggyz in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-26-2015, 12:28 PM
  5. Cell color has to change for all updated cells on daily basis
    By ajaypal.sp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2015, 11:05 AM
  6. Change the Back Ground Color on basis of content of cell in a range
    By ravinder_tigh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-01-2009, 11:36 PM
  7. Replies: 4
    Last Post: 01-20-2009, 03:11 PM

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