Conditional Formatting for Word and Date [Solved/Closed]

Report
-
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-
Hello,
I am trying to make a cell turn a different color depending on if another cell has a word in it and if the date of a third cell is between two dates. I have for formula for adding them up, but now I want them to be a specific color. This is the formula I have for the sum.

How can I make these cells a specific color?

=SUMIFS(G2:G173,B2:B173,"*DTC*",D2:D173,">=10/1/2014",D2:D173,"<=10/03/2015")


2 replies

Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3482 users have said thank you to us this month

Posts
1
Registration date
Saturday December 31, 2016
Status
Member
Last seen
January 1, 2017

Thank you so much!!! That worked perfect!
Posts
1829
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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