Hi bec,
For this I'm assuming row 6 and the cell containing the relevant date is D6.
Select row (or better still just the cells containing data within row 6),
then 'Format - Conditional Formatting'
Select 'Formula is' in the first drop-down, then enter this formula:
=if(D6<=TODAY(),true)
Then click the 'Format' button to choose how you want the cells to be shown
when the condition is true.

There's a lot more you can do with this so check out the Excel help for
further features.

If you copy the format down more rows the conditional format will go with it.#

HTH

Giz

"bec" wrote:

If i want a row to turn red when todays date is equal to or passed the date
in a cell what formula do i use?