Results 1 to 14 of 14

Formula for highlighting a cell when time equals NOW

Threaded View

kvallecillo Formula for highlighting a... 03-24-2019, 08:58 AM
6StringJazzer Re: Formula for highlighting... 03-24-2019, 10:00 AM
kvallecillo Re: Formula for highlighting... 03-24-2019, 10:32 AM
jason.b75 Re: Formula for highlighting... 03-24-2019, 11:41 AM
kvallecillo Re: Formula for highlighting... 03-24-2019, 01:03 PM
jason.b75 Re: Formula for highlighting... 03-24-2019, 01:09 PM
kvallecillo Re: Formula for highlighting... 03-24-2019, 01:18 PM
jason.b75 Re: Formula for highlighting... 03-24-2019, 01:24 PM
kvallecillo Re: Formula for highlighting... 03-24-2019, 01:36 PM
jason.b75 Re: Formula for highlighting... 03-24-2019, 01:48 PM
kvallecillo Re: Formula for highlighting... 03-24-2019, 02:10 PM
jason.b75 Re: Formula for highlighting... 03-24-2019, 02:33 PM
kvallecillo Re: Formula for highlighting... 03-24-2019, 02:53 PM
jason.b75 Re: Formula for highlighting... 03-24-2019, 05:29 PM
  1. #1
    Registered User
    Join Date
    09-28-2018
    Location
    El Salvador
    MS-Off Ver
    365
    Posts
    21

    Formula for highlighting a cell when time equals NOW

    Hello again guys, first of all I would like to thank you in advance for the help.

    Lately, I have been trying to improve the formula for highlighting a cell when time= NOW, which has been very helpful. However, since a lot of people is coming to the company, I am having difficulties with adding everyone's information because I have to do it manually. Basically, the rule I am following is "show the status a person should be (available, break, lunch, off) when time=NOW ()" in other words, IF "T3:Z64" of 'Schedules!'= Now() THEN apply the custom formula. I'm sorry if I am not being clear. Please don't hesitate to ask. See the attached file for references.

    Thanks in advance,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for If the Sum Equals Zero, leave cell blank
    By knuckledownlacrosse in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2019, 10:22 PM
  2. Looking for function to run a formula if cell equals
    By Monkei in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2017, 12:09 PM
  3. Highlighting Cell Depend On two criteria date and time
    By udprocks in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-16-2016, 05:05 AM
  4. [SOLVED] formula equals cell directly above
    By Lynne...... in forum Excel General
    Replies: 3
    Last Post: 12-12-2014, 03:00 PM
  5. [SOLVED] Cell equals formula OR manual input
    By PDBartlett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2014, 05:52 AM
  6. [SOLVED] Formula to add 1 to a cell if equals another...
    By muddbog in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2014, 06:38 AM
  7. How run a Macro if cell A1 equals a value derived from a formula
    By Stickleback in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2012, 01:39 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1