gpt-3.5-turbo-0301· OpenAI
WildChat-4.8M (AI2)
I have dates in a column. How can I highlight dates that are le 3years before today
- User
I have dates in a column. How can I highlight dates that are le 3years before today
- Assistant
As an AI language model, I do not have access to your spreadsheet or data. However, here are the general steps to highlight dates that are less than or equal to 3 years before today:
- Select the column of dates that you want to check.
- Click on the "Conditional Formatting" button in the "Home" tab of the ribbon.
- Select "New Rule" from the drop-down menu.
- In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format".
- In the "Format values where this formula is true" field, enter the following formula: =DATEDIF(A1,TODAY(),"y")>=3 (Note: replace "A1" with the cell reference of the first date in your selected column.)
- Click on the "Format" button and choose the desired highlighting format (e.g. background color).
- Click "OK" to close the "Format Cells" dialog box.
- Click "OK" again to close the "New Formatting Rule" dialog box.
This should highlight all the cells in the selected column that are 3 years or more before today.