LinkBack URL
About LinkBacks
Hello,
I have some cells that contain dates in the past and I was wondering if there was an excel function that would turn that cell with the date in it red if that date was more than 30 days in the past.
I have attached a sample workbook.
Thank you
Hello,
I have some cells that contain dates in the past and I was wondering if there was an excel function that would turn that cell with the date in it red if that date was more than 30 days in the past.
I have attached a sample workbook.
Thank you
Select Column B
Click on the Conditional Formatting button on the Home Tab in Excel, and select "Highlight Cell Rules", and then "Less Than"
In the textbox on the Left, type =TODAY()-30
Select the format you want in the other box if necessary
Click OK and done!
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Awesome! Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks