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
I have an excel spreadsheet set up with 4 columns:
Start Date/30 days after Start Date/60 days after Start Date/90 days after Start Date
What I would like to achieve is that when the Start Date has exceeded 30, 60 or 90 days, those certain columns would turn a different color.
So for example, in my first row. If my start date is 3/16/17, all three of the 30, 60 and 90 days should turn red because today is after all three of those dates.
However if my start date was 5/26/17 the only date that should turn red when I log in today, would be the 30 days since the 60 and 90 date is in the future.
Start Date/30 days after Start Date/60 days after Start Date/90 days after Start Date
What I would like to achieve is that when the Start Date has exceeded 30, 60 or 90 days, those certain columns would turn a different color.
So for example, in my first row. If my start date is 3/16/17, all three of the 30, 60 and 90 days should turn red because today is after all three of those dates.
However if my start date was 5/26/17 the only date that should turn red when I log in today, would be the 30 days since the 60 and 90 date is in the future.
Related:
- Conditional Format help
- Format factory - Download - Other
- Kingston format utility - Download - Storage
- Swissknife format - Download - Storage
- Marksheet format in excel - Guide
- Excel date format dd.mm.yyyy - 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.
