Conditional Formatting

Highlight a Row Matching Today’s Date

When working with Rows containing dates, it may be helpful to highlight the row corresponding with Today’s date. If the value is in Column A, utilize the Formula =$A1=TODAY() regardless of what Row the value is in. For Applies to, specify the Columns the highlighted row should change the color, for Example: =$A:$M

Example:

---

Highlight a Row Matching a Date within the Past 5 Days

When working with Rows containing dates, it may be helpful to highlight the row corresponding with Today’s date. If the value is in Column A, utilize the Formula =$A1>TODAY()-5 regardless of what Row the value is in.
For Applies to, specify the Columns the highlighted row should change the color, for Example: =$A:$M

Example:

Distinguishing Rows with Dates a Week or More Apart

To distinguish Rows where the Date specified occurred in a different weeks, utilize the formula: =WEEKNUM($A1)<>WEEKNUM($A2)
For Applies to, specify the Columns the highlighted row should change the color, for Example: =$A:$M

Example:

Cells with a Date Occurring Today

Cells Containing Specific Text

Example:

Cells with a Value Between 0 and 100

Example