Conditional Format help
Closed
jamie_ut
Posts
1
Registration date
Tuesday July 11, 2017
Status
Member
Last seen
July 11, 2017
-
Jul 11, 2017 at 10:53 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 11, 2017 at 11:31 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 11, 2017 at 11:31 AM
Related:
- Conditional Format help
- Format factory - Download - Other
- Kingston format utility - Download - Storage
- Excel date format dd.mm.yyyy - Guide
- Samsung format code - Guide
- Marksheet format in excel - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 11, 2017 at 11:31 AM
Jul 11, 2017 at 11:31 AM
jamie_ut, Good afternoon.
Suppose:
A2 --> Start date
B2 --> Date 30 days after Start Date
C2 --> Date 60 days after Start Date
D2 --> Date 90 days after Start Date
Try to use:
a) Select B2:D2
b) Conditional Format
Using formula
--> =TODAY()>=B2
--> Format: Fill color RED
OK
Please, tell us if it worked as you desired.
Suppose:
A2 --> Start date
B2 --> Date 30 days after Start Date
C2 --> Date 60 days after Start Date
D2 --> Date 90 days after Start Date
Try to use:
a) Select B2:D2
b) Conditional Format
Using formula
--> =TODAY()>=B2
--> Format: Fill color RED
OK
Please, tell us if it worked as you desired.