highlight rows with current date entry

Hi,

I have a excel worksheet with some rows having date entries. i want that the row with current date should get highlighted automatically everyday. how can i do this?

Thanks

Try marking all rows in the subject range and use conditional formatting:

Formula Is =$E8=today()

with E being the column that contains your date and 8 being the currently active row.

Regards,
Mike