A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Here is the formula to add the Conditional Formatting to rows where the Invoice Date is more than 30 days prior to today and Column G has an "N" to indicate that the invoice has not been paid. Follow this procedure.
- Select all of the cells that you would like to be formatted on the delinquent rows. This could include only Column B or multiple columns if you want more of the row highlighted.
- On the Home ribbon open Conditional Formatting>New Rule>Use a Formula. In the Format Values line enter this formula.
=AND($B2+30<TODAY(),$G2="N")
- Click on the Format button at the lower right and choose the formatting you want in the Format Cells dialogue. Then click OK and OK.