0

I made a spreadsheet in google sheets in my last company which highlighted all my rows based on my qualifying conditions. I can't remember what conditional formatting I used.

I have tried the =IFAND and =AND functions along with others.

This is what I am trying to do:

If column B says DTC, even if something else is also in cell, and the dates are between two ranges I want it highlighted. Then I will have multiple rules that vary in dates and words. I have attached a new demo sheet to help.

https://docs.google.com/spreadsheets/d/1yX_Ohfdz0uRKvOB8hvOpcO2sb5dSaAP6Zw-aR_HzK2E/edit?usp=sharing

The formula I have in there now is =AND($B2="DTC",E$2>=DATE(2017,10,1),E$2<=DATE(2018,10,1))

Improve this question
2
  • 1
    This is almost the same question as Google Sheets Conditional formatting based on multiple conditions. You should said that it's a follow up question and that you need that the formula works also for cell containing DTC along with other characters. Commented Jan 5, 2018 at 5:40
  • It is, but the formula is still not working. I copied and pasted the new demo spreadsheet which has the exact code. You told me to ask a new question so that is what I did. I was originally going to edit the other one. This demo sheet is the exact copy of the one I am working on with the extra information taken out. Commented Jan 5, 2018 at 15:05

1 Answer 1

Reset to default
1

To find both DTC and DTC-DCL with a wildcard try using if with search like this:

=if(and(search("DTC*",$B2),$E2>=date(2017,10,1),$E2<=date(2018,10,1)),"true","false")

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.