Results 1 to 8 of 8
  1. #1
    Junior Member
    Join Date
    Oct 2009
    Posts
    5

    Default Excel auto highlight help

    hi all

    this is a call for help to someone who can work excel,

    the situation is;
    Ive pieced together a highlight for my job that automatically changes to highlight the correct date at midnight, the problem is that I need it to change the highlight at 7am instead of midnight to ciencide with the sceduled shifts.
    the conditional formatt that im using is =$a1=today

    help would be very, very apreciated

  2. #2
    IT Contractor
    Join Date
    Feb 2005
    Posts
    2,677

    Default Re: Excel auto highlight help

    What data is in the column you're basing the conditional formatting off, a full time stamp or?
    Windows 7 x64 // i5-3570K // 16GB DDR3-1600 // GTX660Ti 2GB // Samsung 830 120GB SSD // OCZ Agility4 120GB SSD
    Windows 7 x64 // Phenom II 955 // 8GB DDR3-1333 // GTX460 1GB // Corsair Force3 120GB SSD
    Samsung Galaxy S4 GT-I9505

  3. #3
    Junior Member
    Join Date
    Oct 2009
    Posts
    5

    Default Re: Excel auto highlight help

    As of now there are only dates down column A, every cell has a diffrent date.No time data yet. Im trying to figure out how to do it without having the time data visible, or having to take up any extra cells if possible.

  4. #4
    IT Contractor
    Join Date
    Feb 2005
    Posts
    2,677

    Default Re: Excel auto highlight help

    you could try using IF(HOUR(NOW())>6) as a check to see if it is currently 7am or later, in addition to your existing date check or whatever.
    Windows 7 x64 // i5-3570K // 16GB DDR3-1600 // GTX660Ti 2GB // Samsung 830 120GB SSD // OCZ Agility4 120GB SSD
    Windows 7 x64 // Phenom II 955 // 8GB DDR3-1333 // GTX460 1GB // Corsair Force3 120GB SSD
    Samsung Galaxy S4 GT-I9505

  5. #5
    Junior Member
    Join Date
    Oct 2009
    Posts
    5

    Default Re: Excel auto highlight help

    thanx for the help
    I tried using that but nothing happens. When I combine it with the code it gives me an error message, I tried using it by itself to see if I was doing something wrong, but nothing happens

  6. #6
    Junior Member
    Join Date
    Oct 2009
    Posts
    5

    Default Re: Excel auto highlight help

    also I realized I typed the code incorrectly here its actually =$A1=TODAY()

  7. #7
    Senior Member fred_fish's Avatar
    Join Date
    Sep 2009
    Posts
    1,995

    Default Re: Excel auto highlight help

    =AND($A1=TODAY(),HOUR(NOW())>6)

  8. #8
    Junior Member
    Join Date
    Oct 2009
    Posts
    5

    Default Re: Excel auto highlight help

    you.....ROCK!! "fred fish" formula worked perfectly =) adapted it to my workbook thanx

Similar Threads

  1. Highlight facility
    By Old Tom in forum PressF1
    Replies: 5
    Last Post: 11-08-2004, 06:05 PM
  2. Highlight faclity
    By Old Tom in forum PressF1
    Replies: 1
    Last Post: 11-08-2004, 06:45 AM
  3. Excel Auto sort
    By Peter H in forum PressF1
    Replies: 6
    Last Post: 25-01-2004, 04:18 PM
  4. Excel Auto sort
    By Peter H in forum PressF1
    Replies: 6
    Last Post: 24-09-2003, 07:27 PM
  5. Excel and auto filter
    By sims in forum PressF1
    Replies: 2
    Last Post: 14-04-2003, 09:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •