I have a spreadsheet that lists sales information for every day of the year:

Row 1 =January 1 data
Row 2 = January 2 data and so forth
Row 3 = January 3 Data and so forth

Is there a way to format the row so that when excel looks at the current
date it would highlight that days sales information all teh way across?

So if today was the 2nd of january, itwould highklight that row (Row 2) but
tommorrow on the 3rd it would highlight row 3 etc