Conditional Formatting for Word and Date
Solved/Closed
Tiffanypoche
-
Dec 31, 2016 at 05:51 PM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Jan 1, 2017 at 10:06 AM
Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 - Jan 1, 2017 at 10:06 AM
Related:
- Conditional formatting in word
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Vim find word - Guide
- Word free for u - Guide
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- Microsoft word 2019 free download - Download - Word processors
2 replies
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
Jan 1, 2017 at 09:12 AM
Jan 1, 2017 at 09:12 AM
Tiffanypoche, Good morning.
Try to use this formula at Conditional Formatting:
=AND(ISNUMBER(MATCH("*DTC*", $B2, 0)), $D2>=DATEVALUE("10/01/2014"), $D2<=DATEVALUE("10/03/2015"))
Format color you desire;
Applies to: $G$2:$G$173
OK
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use this formula at Conditional Formatting:
=AND(ISNUMBER(MATCH("*DTC*", $B2, 0)), $D2>=DATEVALUE("10/01/2014"), $D2<=DATEVALUE("10/03/2015"))
Format color you desire;
Applies to: $G$2:$G$173
OK
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1980
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
December 22, 2022
146
Jan 1, 2017 at 10:06 AM
Jan 1, 2017 at 10:06 AM
Thanks for the feedback.
I'm glad to have helped.
I wish a year of great health and accomplishments for you and your family.
--
Belo Horizonte, Brasil.
Marcílio Lobão
I'm glad to have helped.
I wish a year of great health and accomplishments for you and your family.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Jan 1, 2017 at 09:23 AM