Question: How do I highlight dates that meet a criteria using conditional formatting?

Table of contents

Highlight values in a column

Highlight values in a row

Highlight records

Sort values

Highlight values in a column

highlight-values-in-a-column2

How to apply the conditional formatting formula in excel 2007:

  1. Select the range (A1:A10)
  2. Click "Home" tab on the ribbon
  3. Click "Conditional formatting"
  4. Click "New rule..."
  5. Click "Use a formula to determine which cells to format"
  6. Click "Format values where this formual is true" window.
  7. Type
    =(A1<=$D$2)*(A1>=$D$1)
  8. Click Format button
  9. Click "Fill" tab
  10. Select a color
  11. Click OK!
  12. Click OK!

Highlight values in a row

highlight-values-in-a-row2

Conditional formatting formula in cell range A5:E5:

=(A1<=$D$2)*(A1>=$D$1)

Highlight records

highlight-records2

Conditional formatting formula in cell range A6:C15:

=($A6<=$B$2)*($A6>=$B$1)

Sort values

You can quickly sort highlighted records to the top of the list.

  1. Select cell range A6:C15
  2. Right click on cell range
  3. Click "sort"
  4. Click "Put selected cell color on top"

All highlighted records are on top.

Download excel *.xls file

highlight-dates-in-range-using-conditional-formatting2.xls

(Excel 97-2003 Workbook *.xls)