+ Reply to Thread
Results 1 to 1 of 1

If Windows date and time crosses given input date and time then excel should indicate.

  1. #1
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    657

    If Windows date and time crosses given input date and time then excel should indicate.

    Hello Friends

    OS : Windows 10
    Excel : Excel 2016 (Ignore .xls in attachment file)

    This time i came with different application. In the attached excel file in A1 date is plotted and B1 time is plotted, Now excel file should indicate automatically to change the background filled cell color to Light Red in all Excel files and sheets which is currently opened once the windows time passed the given date and Time in A1 and B1.

    If `Formula' is enough then happy, or if `Macro' is required then also `Ok'.

    Note : This is because in Windows 10 Schedule tasker is not working and attempted to use Excel. Now if i am opening daily 1 time 1 particular excel file and in excel sheet this purpose is being solved but not for time basis.

    Thanks in advance.
    Attached Files Attached Files
    Sekar

+ 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. [SOLVED] Convert Unix Date-time stamp to excel date and/or time columns
    By judikz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2015, 05:46 PM
  2. Replies: 9
    Last Post: 02-15-2015, 07:32 PM
  3. Replies: 3
    Last Post: 12-19-2013, 06:49 AM
  4. Excel 2013 not Working on Windows 8 (Date & Time)
    By edison in forum Excel General
    Replies: 11
    Last Post: 06-23-2013, 09:59 AM
  5. modify date time cell to an excel format date time
    By rileyp in forum Excel General
    Replies: 12
    Last Post: 03-24-2013, 08:39 PM
  6. Date & time auto generated based on input date & time
    By BlastRanger in forum Excel General
    Replies: 18
    Last Post: 09-08-2010, 03:54 AM
  7. [SOLVED] Calculating days & time left from start date/time to end date/time
    By marie in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2005, 10:40 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