Results 1 to 3 of 3

Conditional Formatting on this Annual Leave Form

Threaded View

  1. #1
    Banned User!
    Join Date
    09-26-2015
    Location
    Manchester
    MS-Off Ver
    2013
    Posts
    218

    Conditional Formatting on this Annual Leave Form

    Hi All,

    Further to an earlier post, can someone take a look at my attached Annual Leave Form. With reference to the calendar, currently the Saturday AMs are coloured grey (which means this is a weekend) and the Saturday PMs have no fill colour (which signifies a working day). In fact, it should be the reverse. Saturday AMs should be no fill and Saturday PMs should be grey. Can someone look into why the conditional formatting formula isn't functioning the way I thought it would and possibly resolve for me?

    Thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 06-25-2016, 11:10 AM
  2. [SOLVED] % of staff on annual leave
    By tfograham in forum Excel General
    Replies: 6
    Last Post: 07-22-2015, 03:46 PM
  3. Annual Leave and Sick Leave fiel
    By lauphyon in forum Excel General
    Replies: 2
    Last Post: 06-24-2014, 05:00 AM
  4. Track Annual Inspection Due Dates Using Conditional Formatting
    By Scatman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-29-2014, 07:20 PM
  5. Sick leave annual leave minutes spreadsheet
    By News12kim in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-22-2013, 03:28 AM
  6. Replies: 1
    Last Post: 05-18-2011, 10:46 PM
  7. Annual Leave
    By Aussie Peter in forum Excel General
    Replies: 1
    Last Post: 01-30-2006, 11:30 PM

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