Annual leave planner

  • Re: Annual leave planner

    Hi kennethbrandon -

    For the conditional formatting, highlight cell H8 and make your conditional format formula read:


    and then drag down the formatting.

    For the Total Annual Leave (column AM), this formula works for me:


    Hope that helps!

  • Re: Annual leave planner

    Hi abba92,
    Thank you very much for sharing with me.
    The Total sum for column AM works perfectly! I have used your formula for Conditional Formating but it does'nt work when the week end "Sunday" and Year changes. Is there any other alternatives besides =$D8<>""? Thanks again.

  • Re: Annual leave planner

    Hi kennethbrandon - Highlight E7:AI52 (with E7 as the active cell) and conditional format using the formula:


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!