Excel Conditional Formatting with the TODAY function | Duplicate Rule

Posted on:  05/16/2022
Excel Conditional Formatting with the TODAY function | Duplicate Rule

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.

Excel Conditional Formatting with the Today Function

Excel Conditional Formatting with the Today Function

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.

Recent Microsoft Word articles

YouTube Video - Conditional Formatting with the TODAY Function

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
Recent Teams articles

TODAY Function

=TODAY() The TODAY function has no arguments and will return the current date. When the file is open again, the date will automatically update.It is a great Date & Time Function. 

 

TODAY Function in Excel

TODAY function in Excel

Conditional Formatting Rules

Three rules:

  1. Greater Than
  2. Less Than
  3. Equal To
Conditional Formatting Rules

Three conditional formatting rules

Recent Excel Articles

Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row.

Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row.

Excel - How to find the Greater Common Divisor (GCD Function) and show as Ratios

Excel - How to find the Greater Common Divisor (GCD Function) and show as Ratios

Liquidity Ratio using Excel

Liquidity Ratio using Excel

Excel COUNTIF Function With Wildcard Search and Cell Reference

Excel COUNTIF Function With Wildcard Search and Cell Reference

Excel Status Bar - Tips Every User Should Know

Excel Status Bar - Tips Every User Should Know

How to SORT Data in Excel | 7 Tips

How to SORT Data in Excel | 7 Tips

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 800 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 12 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories