On Wednesday, February 3, 2021 at 12:49:18 AM UTC+5:30,
claus...@t-online.de wrote:
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
Hi all,
I have a situation where, A=follow UP, Invite Sent, B= Last contacted Date, I need to highlight the cell in B which is more than/ above
1. 30 days,
2. 60 days,
3. 90 days,
4. 15 days,
5. 3 days.
What formula could be used in each case. to assign different colors in cell B
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)