Excel Conditional Formatting with Dates using AND and TODAY Functions
Автор: Chris Menard
Загружено: 2022-07-13
Просмотров: 115161
Conditional Formatting is one of Excel's best features. We use a lot of date fields in Excel. Hire date, purchase order date, invoice date, ship date, and other date fields. We will use Conditional Formatting with dates in this video. we will use Conditional Formatting with the default Date options, and then write a rule using dates. The TODAY function is a great function to use when writing formulas with dates.
Chapters
0:00 Intro
0:15 Today function
1:00 Conditional Formatting - A Date Occurring
2:00 Conditional Formating with Functions
4:50 AND function
5:50 Conditional Formatting with AND and TODAY
#chrismenardtraining #exceltraining #msexcel #conditionalformating #microsoftexcel
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
