Conditional formating to highlight dates 30, 60, and 90 days o
Hi,
Am Tue, 2 Feb 2021 11:12:40 -0800 (PST) schrieb Patrick Blanc:
Does anyone know how to highlight dates that are older than 30 days?
For example, today is 2/2/2021.
If I have the date 1/1/2021 in a cell, I want to use conditional formatting to highlight this date because at least 30 days have passed since 1/1/2021. Can anyone help with this?
if your date is in A1 then try in conditional formatting:
=A1<=Today()-30
Regards
Claus B.
--
Windows10
Microsoft 365 for business
|