highlighting rows

mariatoader 

You can use conditional formatting to highlight rows in Excel based on renewal dates.

Here’s how you can do it:

1. Select the cells that contain the renewal dates.
2. Click on the “Home” tab in the ribbon, and then click on “Conditional Formatting” in the “Styles” group.
3. Select “New Rule” from the drop-down menu.
4. In the “New Formatting Rule” dialog box, select “Use a formula to determine which cells to format”.
5. In the formula field, enter a formula that checks if the renewal date is within the next month. For example, if your renewal dates are in column A, you can use this formula: =AND(A1>TODAY(),A1<=EDATE(TODAY(),1))
6. Click on the “Format” button and select the formatting options that you want to apply (e.g., fill color = red).
7. Click on “OK” to close the “Format Cells” dialog box.
8. Click on “OK” to close the “New Formatting Rule” dialog box.

Repeat these steps to create another conditional formatting rule for renewal dates that are within the next 3 months. In step 5, use this formula: =AND(A1>EDATE(TODAY(),1),A1<=EDATE(TODAY(),3)) and select a different fill color (e.g., amber) in step 6.

I hope this helps!