+ Reply to Thread
Results 1 to 3 of 3

Showing available times on staff rota

Hybrid View

wildeone2010 Showing available times on... 02-26-2010, 01:17 PM
Huron Re: Showing available times... 02-26-2010, 07:33 PM
wildeone2010 Re: Showing available times... 02-26-2010, 08:11 PM
  1. 02-26-2010, 01:17 PM #1
    wildeone2010 is offline
    Registered User
    Join Date
    02-22-2010
    Location
    worksop, england
    MS-Off Ver
    Excel 2007
    Posts
    6

    Smile Showing available times on staff rota

    Hi guys. Hope somebody can help me on this one!!!

    It is a formatting problem based on an INDEX formula i believe, but I am unsure where to start.

    I have added a template where I have shown examples of what i want to achieve, the explanation is a lot clearer.

    Any help would be much appreciated.

    Thanks in advance
    Attached Files Attached Files
    Last edited by wildeone2010; 02-26-2010 at 08:13 PM. Reason: To show solved
    Reply With QuoteRegister To Reply
  2. 02-26-2010, 07:33 PM #2
    Huron is offline
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: Showing available times on staff rota

    Use this formula for conditional formatting in cells B5:AK13

    =OR(B$4<$AM5,B$4>=$AN5)
    Reply With QuoteRegister To Reply
  3. 02-26-2010, 08:11 PM #3
    wildeone2010 is offline
    Registered User
    Join Date
    02-22-2010
    Location
    worksop, england
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Showing available times on staff rota

    Thank you very much Huron.

    The formula works a treat thank you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1