Author: Oscar Cronquist Article last updated on February 01, 2019

Cell range B3:B14 has conditional formatting applied, the formula checks if the date is today.

Conditional formatting formula:

=TODAY()=B3

A conditional formatting formula must evaluate to TRUE or FALSE or their equivalents any number or 0 (zero).

The TODAY function returns today's date. The equal sign compares the value to the date in cell B3 and returns TRUE or FALSE.

How to apply conditional formatting to a cell range

  1. Select cell range.
  2. Go to tab "Home"
  3. Click "Conditional Formatting" button.
  4. Click "New Rule..."
  5. Select "Use a formula to determine which cells to format"
  6. Type the formula in field "Format values where this formula is true:"
  7. Click "Format" button, then pick a formatting.
  8. Click OK button.
  9. Click OK button.

Highlight records based on date being today

Conditional formatting formula:

=TODAY()=$B3

This CF-formula is applied to cell range B3:D12.

Weekly Blog EMAIL

Welcome! I am Oscar and here to help you out.

Feel free to comment and ask Excel questions.

Make sure you subscribe to my newsletter so you don't miss new blog articles.

Related articles