Conditional Formatting for Word and Date [Solved]

Ask a question Tiffanypoche - Last answered on Jan 1, 2017 at 10:06 AM by Mazzaropi
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?


plus moins
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

Is that what you want?
I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
Was this answer helpful?  
Tiffanypoche 1Posts Saturday December 31, 2016Registration date January 1, 2017 Last seen - Jan 1, 2017 at 09:23 AM
Thank you so much!!! That worked perfect!
Leave a comment
plus moins
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
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!