Forum

Notifications
Clear all

Conditional design for dates

3 Posts
3 Users
0 Reactions
101 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 
Attached is a file with dates.
Who will design the cell on each date in its last 30 days
So if today's date - occurs in the last 30 days of the date written in the cell - will shape the cell

Dodge in the file will design 21/3/22 because today's date - 16/3/22 occurs during the last 30 days of 21/3/22
 
 
Posted : 17/03/2022 6:08 am
(@questvba)
Posts: 125
Estimable Member
 

Hi lea,

Here is your file with conditional formatting.

See : Use conditional formatting to highlight information

BR,

Lionel

 
Posted : 18/03/2022 1:49 am
(@petter001)
Posts: 1
New Member
 

 Your file with conditional formatting is very good and help full for me. There is a lot of data in your file which is so help full for me I have to share this file with my friends because file is so intresting and help full Thank you very much.

 
Posted : 19/03/2022 3:38 am
Share: