Results 1 to 5 of 5

Conditional formatting on adjacent cell

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2013
    Location
    Home
    MS-Off Ver
    Excel 2007
    Posts
    13

    Conditional formatting on adjacent cell

    Dear all,

    I have data as attached.
    I wish to do the following. All time in after 9:01 is highlighted in red, before 09:00 is green.
    For cells with 00:00 it should be in yellow.
    However the highlighted area is not only the cells but the adjacent of it as shown.

    If weekends could be avoided for formatting i.e. not in any colour that would be better.


    Thank you for your help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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