Article updated on December 22, 2017

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

Highlight values in a column

Highlight values in a row

Highlight records

Sort values

### Highlight values in a column

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

Conditional formatting formula in cell range A5:E5:

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

### Highlight records

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.