The TODAY function is one of my favorite Date & Time functions in Excel. It returns the current date and will automatically update. We will use the TODAY function with Conditional Formatting and create three rules on a date field. The date field can be any date field - order date, invoice date, request date, etc. I used the ship date in my example. If the cell's date equals the current date, we will put that one color, any dates less than today's date in another color, and dates greater than today in a third color.
Conditional formatting is located on the home tab. After writing the first rule, =$G2=TODAY(), I copied the rules to create the other two rules. Here is a screenshot of all three rules.
drive.google.com/file/d/1EwFe6Sl7IWyDThkqsZnL32uwNHElO44y/view?usp=drivesdk
Chapters/Bookmarks
0:00 Intro
0:26 Ship date
0:44 Rule 1 - $G2=TODAY()
1:47 Mixed Reference
3:57 Rule 2 - Duplicate rule
4:47 Rule 3
5:20 Resize Conditional Formatting
Blog post chrismenardtraining.com/post/excel-conditional-formatting-with-the-today-function-duplicate-rule-2257
#msexcel #chrismenardexcel #microsoftexcel #microsoft #exceltraining
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – 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!
- Excel Conditional Formatting with the TODAY function | Duplicate Rule ( Download)
- Excel Conditional Formatting with Dates using AND and TODAY Functions ( Download)
- Excel Tiered Conditional Formatting with Dates using functions AND and TODAY ( Download)
- Excel Conditional Formatting for Dates in the Past/Future/Today ( Download)
- Conditional Formatting Formulas - Mystery Solved with 3 Simple Rules ( Download)
- Excel - Conditional Formatting find duplicates on two worksheets by Chris Menard ( Download)
- How to Fix Excel Conditional Formatting Duplicated Rules ( Download)
- Excel How To: Format Cells Based on Another Cell Value with Conditional Formatting ( Download)
- Threshold Alert in Excel to Highlight Expiration Dates | Conditional Formatting | Today Formula ( Download)
- How to: Use Conditional Formatting Rules in Sheets ( Download)
- 9. conditional formatting with date and highlight duplicate ( Download)
- Conditional Formatting in Excel | Highlight Marks Pass/Fail #shorts #excel ( Download)
- Conditional Formatting in Excel Tutorial ( Download)
- Highlight Duplicates in Google Sheets SHORTS || Use Conditional Formatting to Find Duplicates ( Download)
- Spot Duplicates Like a Pro! ️ 2 #excel Conditional Formatting Tricks #exceltips ( Download)
