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

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!

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

    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