Results 1 to 3 of 3

Thread: Leave Roster

  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Leave Roster

    I have set up a Leave Roster

    I would like the following to be incorporated

    1) Where there are public holidays, the row containing the public holidays to be in green
    2) The row containing Saturdays and Sundays to be in yellow -I have tried to use conditional formatting to highlight all Saturdays & Sundays using formula =WEEKDAY(A$8,2)>5, but the entire sheet is highlighted
    3) A summary sheet by month showing the closing leave balance per employee. I tried to set up a Pivot table, but it was messy


    Your assistance in assisting me is most appreciated
    Attached Files Attached Files

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 645 Times in 589 Posts
    Howard,

    Use the following conditional formulas:

    Weekends:
    =WEEKDAY(DATE(YEAR($B8),MONTH($B8),DAY($B8)),2)>5

    Specified Holidays:
    =COUNTIF($X$3:$X$14,$B8)>0

    with the range =$B$8:$U$282

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Thanks for the help Maud, much appreciated

Posting Permissions

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