Looking for a formula to highlight an entire row when a date in column J is 60 or < days than current date in Excel

Meagan Dally 20 Reputation points
2024-07-02T17:28:16.51+00:00

I need a formula for conditional formatting that will highlight a row when the date in column J is <60 days from current date. Any help would be appreciated!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,681 questions
0 comments No comments
{count} votes

Accepted answer
  1. Barry Schwarz 2,511 Reputation points
    2024-07-02T21:57:32.9466667+00:00

    Select the rows of interest clicking on the row numbers. For example, 11 through 28. On the home tab, select Conditional Formatting -> New Rule -> Use a formula. Enter the formula "=AND($J11>TODAY()-1,$J11<TODAY()+60)" without the quotes.


0 additional answers

Sort by: Most helpful