Formula/ Conditional Formatting Help please
Closed
Amygreen85
Posts
3
Registration date
Wednesday August 23, 2017
Status
Member
Last seen
December 19, 2017
-
Dec 14, 2017 at 04:48 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 19, 2017 at 09:50 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Dec 19, 2017 at 09:50 AM
Hello,
I am trying to create a tracker spread sheet. I need to enter the date a course was completed, the date it is due (2 years later) and I need it to highlight in red when it is 6 months before the due date in order to allow time to arrange the next course. Can anyone please help. The course was completed on 05/12/2017 and will be due on the 05/12/2019. so I need it to go red 6 months before 05/12/19.
Any help or advice would be greatly appreciated. Thanks in advance.
I am trying to create a tracker spread sheet. I need to enter the date a course was completed, the date it is due (2 years later) and I need it to highlight in red when it is 6 months before the due date in order to allow time to arrange the next course. Can anyone please help. The course was completed on 05/12/2017 and will be due on the 05/12/2019. so I need it to go red 6 months before 05/12/19.
Any help or advice would be greatly appreciated. Thanks in advance.
Related:
- Formula/ Conditional Formatting Help please
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 14, 2017 at 07:22 AM
Dec 14, 2017 at 07:22 AM
Amygreen85, Good morning.
Suppose:
D3 --> DUE DATE --> 05/12/2019
CONDITIONAL FORMATTING
Select D3
Menu --> Format --> Conditional Cormatiing
1st Rule
The formula is: =TODAY()>EDATE(D3;-6)
Format: Background colour RED
OK
Please, tell us if it worked.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Suppose:
D3 --> DUE DATE --> 05/12/2019
CONDITIONAL FORMATTING
Select D3
Menu --> Format --> Conditional Cormatiing
1st Rule
The formula is: =TODAY()>EDATE(D3;-6)
Format: Background colour RED
OK
Please, tell us if it worked.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Dec 19, 2017 at 09:50 AM
Dec 19, 2017 at 09:50 AM
Amygreen85, Good morning.
Since you did not say what the mistake is, it gets a bit more difficult to help.
But maybe it could be the separator inside the EDATE function.
It may be that your version uses a comma (,) instead of a semicolon (;) in separating the operators from a function.
Try to use:
=TODAY() > EDATE(D3,-6)
instead of: =TODAY()>EDATE(D3;-6)
Please, tell us if it worked.
I hope it helped.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Since you did not say what the mistake is, it gets a bit more difficult to help.
But maybe it could be the separator inside the EDATE function.
It may be that your version uses a comma (,) instead of a semicolon (;) in separating the operators from a function.
Try to use:
=TODAY() > EDATE(D3,-6)
instead of: =TODAY()>EDATE(D3;-6)
Please, tell us if it worked.
I hope it helped.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Dec 19, 2017 at 05:30 AM
Thank you