highlighting rows

Copper Contributor


so i have a row with renewal dates some from last year and im tring to add 2 formulas : one to highlite with red everyting that is coming for renewal in the next month and with amber what comes for renewal in the next 3 month. Can you please help newbie here : )

3 Replies


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!

@NikolinoDE thank you but it didnt work :(


Please include the following info to help others answer your question:

Welcome to your Excel discussion space!


Thank you for your understanding and patience