Conditional Format cells based on =Now()

    Hello,


    I have a spreadsheet that contains employee break times and lunch times. I want to highlight the cells that should be on a break or lunch based on the current time of day. I honestly do not know where to start for afromula that will calculate this. The cells need to be highlighted for their duration of their specific time.. (i.e break is 20 minutes, lunch is 35 minutes).


    Is there anyone that could possibly point me in the right direction?


    My data starts from colums F to M

    Re: Conditional Format cells based on =Now()


    I/we would need to see a copy of your spreadsheet and how you record the data to be of any assistance. Have you tried using the conditional format tab(icon) in conjuction with your formulas?

    [SIGPIC][/SIGPIC]Streub


    "Zero to Hero and Back in 6 Seconds."

    Re: Conditional Format cells based on =Now()


    A ...F
    Jack08:00:00 AM10:00:00 AM10:20:00 AM12:00:00 PM12:35:00 PM02:00:00 AM02:20:00 AM04:30:00 AM
    Jill09:00:00 AM11:00:00 AM11:20:00 AM01:00:00 PM01:35:00 PM03:00:00 AM03:20:00 AM05:30:00 AM



    I'm guessing your 8 columns are start and stop times of each break.


    Then you could do 3 separate conditional formats (based on formula) and apply them to whichever cells you want formatted:
    =AND(NOW()>$G3,NOW()<$H3)
    =AND(NOW()>$I3,NOW()<$J3)
    =AND(NOW()>$K3,NOW()<$L3)


    Here's a link on how to do conditional formats.
    If that doesn't get you there, we would need to see your spreadsheet like Streub said.


    -Chris

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login