Highlight Weekdays and Weekends Using Conditional Formatting in Excel

In this video, you will learn how to highlight
1. Weekends using weekday and conditional Formatting
2. Weekdays using weekday function and conditional formatting.
Watch more on weekday function using the following link.
• How to use Weekday,Wee...
~-~~-~~~-~~-~
Please watch: "How to Use Concatenate With Vlookup in Excel "
• How to Use Concatenate...
~-~~-~~~-~~-~

[@tanmoydas1477]

Thank you mam!

[@HarrisMir-t7o]

Thank you. It really helped me with my project.

[@rifakhatoon709]

Awesome explained

[@01.SARIPHIDAYAT]

Thanks, nice information

[@karpagamexcelprime]

Thanks for liking the video Sarip Hidayat

[@GregoryTinn]

I'm working on a schedule for work, during the week there are two shifts and on the weekend there are three shifts. I want to have Monday thru Friday then a row to add in the different times for the weekend and then a row again to add in the time for the weekdays I want this pattern to repeat and also change for every month??

[@vyasinfotechvs9200]

One querry mam our companies holiday (weekend) is on Thursday so How to highlight the Thursday only... Or Sunday only ?

[@2310546]

How to do conditional use formatting if for example a vendor has weekly limit of Invoice posting limit how to highlights on which week the limit got exceeded

[@associateengineer204]

would you like to tell me how to highlight (Every Friday) of the month with Conditional Formatting to whole row?

[@karpagamexcelprime]

You can highlight any of the weekdays using conditional formatting. Shortly I will make a video and share the same with you.

[@karpagamexcelprime]

Most welcome ajinkya naik

[@kumarsharmaajit4811]

can we highlight randomly 2 days in a week?

[@garlicjuice]

shortcut for formatting is Alt + O + D and then choose New rule
For those who can't understand because of accent like me

[@SiFu_ConFuSus]

Why are we choosing 2? I don't understand that.

[@juhisingh1419]

Formula not explained well