How to highlight a row in a listview?

Excel Conditional Formatting, Highlight Row Based On One Cell?

• I am trying to make a spreadsheet that contains 9 columns and will have an undefined amount of rows....the first row being a date. What I would like to happen, is if today's date is 14 days later than the day listed in that particular column, I would like the entire row to highlight yellow. Please help!

• Answer:

  I assume you mean the first 'column' contains a date. If so, you can conditionally format each row using a formula. For Excel 2003, and prior: ==================== Highlight the entire range of cells that you wish to conditionally format, beginning with the first cell in column A that you wish to format. Go to Format > Conditional Formatting. In the drop down beneath Condition1, select Formula Is Enter this formula in the text box to the right: =AND($A1< TODAY()-14,$A1<>"") Click 'Format', select the Pattern tab, and choose the Yellow you wish to use. Click 'OK' twice. All columns in any row where the date in column A is more than 14 days ago will highlight yellow. For Excel 2010: ============ Highlight all cells as above. Select the Home tab and click the Conditional Formatting drop down in the Styles group and select 'New Rule'. In the 'Select a rule type' section, click 'Use a formula to determine which cells to format'. In the Format values where this rule is true textbox enter the formula above. Click 'Format' and select the 'Fill' tab. Choose the Yellow you wish to use and click 'OK' twice. Edit: this example uses cell A1 as the first cell in column A to contain the formatting. Adjust the cell reference as required.