Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,668 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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!
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.