Hi,
i. I have tried to hihglight the weekend at column H6 until the last staff name with conditional formating but it only highlighted column "H6:H7".
ii. What formula should I use to get rid of "0" value at column "AM8:AM52". I have used "0;-;;@" but it deleted the "negatives value".
Would you please help me, Thank you.
Re: Annual leave planner
Hi kennethbrandon -
For the conditional formatting, highlight cell H8 and make your conditional format formula read:
=$D8<>""
and then drag down the formatting.
For the Total Annual Leave (column AM), this formula works for me:
=IF(SUM(AK8-AL8)=0,"",SUM(AK8-AL8))
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:
=WEEKDAY(E$7,2)>6
Re: Annual leave planner
Hi abba92,
It works! Thank you very much for helping me. May God bless you.
Don’t have an account yet? Register yourself now and be a part of our community!
