What is the formula to highlight rows in Excel?

[Eddie Rivera]

Does anyone know of a formula to highlight rows in Excel? I have used Conditional Formatting but I need a formula to find past due and upcoming dates.
Thanks in advance for your help!

[Rabbit]

You can use conditional formatting for that.

[Eddie Rivera]

Rabbit,
Thanks for your quick response!
I do use the Conditional Formatting for highlighting cells but I need the rows, too, to be highlighted as well. How can I get the Conditional Formatting to hi-lite the rows?

[Rabbit]

I assume you're using some formula to calculate whether or not to highlight the cell. You can use the same formula for the other cells as long as you use absolute referencing for the cell.