Results 1 to 6 of 6

Thread: conditional formatting with time format
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2015
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default conditional formatting with time format

    hi all,
    if i want to enter a time with format([$-en-US,1]hh:mm) in A1, how can i easily track in column B, if time is larger than A1, bold/color the cell automatically?

    thanks

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: conditional formatting with time format

    Hi,

    You can use following formula : =B1>$A$1

    Hope this will help

  3. #3
    Board Regular
    Join Date
    Mar 2015
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: conditional formatting with time format

    Quote Originally Posted by James006 View Post
    Hi,

    You can use following formula : =B1>$A$1

    Hope this will help
    thanks james
    am i wrong?

  4. #4
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: conditional formatting with time format

    Have you tested the formula ...?

  5. #5
    Board Regular
    Join Date
    Mar 2015
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: conditional formatting with time format

    Quote Originally Posted by James006 View Post
    Have you tested the formula ...?
    it's good now, i messed sth, i am sorry.
    thanks james in advance

  6. #6
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: conditional formatting with time format

    You are welcome

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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