Conditional Formatting for Word and Date [Solved/Closed]

- - Latest reply: Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
- Jan 1, 2017 at 10:06 AM
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")


See more 

2 replies

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

Say "Thank you" 1

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

CCM 5744 users have said thank you to us this month

Tiffanypoche
Posts
1
Registration date
Saturday December 31, 2016
Status
Member
Last seen
January 1, 2017
-
Thank you so much!!! That worked perfect!
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
130
0
Thank you
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