Conditional Formatting for Word and Date [Solved/Closed]

Report
-
Posts
1915
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 13, 2021
-
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
1915
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 13, 2021
142
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 2942 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
1915
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 13, 2021
142
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!