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. Press with left mouse button on "Conditional Formatting" button.
  4. Press with left mouse button on "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. Press with left mouse button on "Format" button, then pick a formatting.
  8. Press with left mouse button on OK button.
  9. Press with left mouse button on 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

[newsletter_signup_form id=1]
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