Check Expire Date

Conditional formatting should do the trick for her. Assuming the date to check against is in cell A7, highlight desired cells in the row to color red, click Format>Conditional Formatting...

Set Condition 1 to Formula is and enter =A7<"today()" in the formula box. click Format and then the Patterns tab to select the fill color for the cells.

click OK, OK to close the dialog box.

Note: you may want to adjust the font color to yellow to show better against the red background.

You can then Copy/Paste Special/Formats this range to any other rows that need this formatting.

HTH

What you ask simply requires the addition of a second 'condition'. On the Cond. Formatting box, click "Add>>" and in condition 2 enter:

Formula Is: =A7<TODAY()+30

Set your color (yellow) and fonts as desired.

Now, rows with dates within 30 days of today will be yellow, dates today or older will be red.

HTH

A7 is simply an example cell reference to be adjusted as needed to meet the set up of the worksheet being used.

The OP had stated they wanted to check a specific date against the current date [=Today()]. The formatting can then be copied/Paste Special>Formats to as many cells, rows, columns as desired. With a relative cell reference in the formula, it will adjust itself as it is copied to other cells. If you are moving this around, but only checking the date in column "A", fix the reference as: =$A7<"today()"

Therefore, if the date you want to check against is in D12 (for example), just change the formula to read =D12<"today()", or fix the reference as =$D12<"today()" as needed.

HTH