How to indicate stat holidays on your work schedule in Excel

How to indicate stat holidays on your work schedule in Excel
How to conditionally format with dates. How to conditionally format to format the entire sheet.
For more help visit my website www.easyexcelanswers.com or email me at [e-mail].
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting www.calendly.com/easyexcelanswers
I am able to provide online help on your computer at a reasonable rate.
www.amazon.com/shop/barbhende...
Check out my next one-hour Excel Webinar
www.crowdcast.io/easyexcelans...
I use a Blue condensor Microphone to record my videos, here is the link
amzn.to/37gyyGa
Check out Crowdcast for creating your webinars
app.linkmink.com/a/crowdcast/83
If you need to buy Office 2019 follow
amzn.to/2VX5dv8
Apart from Staff Scheduling, If Your Need Other HCM Software Solutions. Click Below:
www.a3logics.com/hcm-solutions
I use Tube Buddy to help promote my videos
Check them out
www.Tubebuddy.com/easyexcelan...
Follow me on Facebook
/ easyexcel.answers
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
ruclips.net/user/timedtext_cs_p...
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.

[@tatooma1]

Thank you! Barb, I've sent you an email, I have a question, how could we have a conclusion of the whole year attendance in a separate sheet for ‘Only’ these who were on Sick or A leaves with the dates of their absences in a Colum beside their names.
thanks xxx

[@ismailismaili0071]

Nice

[@erikguzik8204]

WOW - so much hardcoding of numbers, this really breaks the golden rule of Excel, and the process is not recommended. You should make a list of ALL holidays for the year(s) of your schedule then use the MATCH() function in the conditional formatting rule.

[@BarbHendersonconsulting]

there is not coding, it uses conditional formatting

[@erikguzik8204]

@@BarbHendersonconsulting it not code I know.. it's called "Hard Coding" when you put static numbers in a formula. It's a bad idea