conditionally format entire row for dates 15 days past today's date?

Highlght the whole row 1 and in conditional formatting rules try this.

Formula:

Please Login or Register  to view this content.

How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.

So close Fotis1991! Thank you! Is there a way to highlight the entire row though through to cell G? This just highlights the individual cell, and I did select the row before going into coniditional formatting. It did stop highlighting the blank cells though.

Highlight range A1:G1 and use this

Formula:

Please Login or Register  to view this content.