+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting on this Annual Leave Form

  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.

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Conditional Formatting on this Annual Leave Form

    Check the order of your conditional formatting rules.

    If you haven't ticked the 'Stop if true' boxes then, in the case of multiple rules being applicable, the one closest to the bottom off the list will be used.

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

    Re: Conditional Formatting on this Annual Leave Form

    Solved it. Just needed to shift the rows down, that's all.

+ Reply to Thread

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