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:


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:


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