CODEWITHSUNDEEP
google-sheetsgs-conditional-formatting
Tiffany Poche
Tiffany Poche

Reputation: 3

Google Sheets Custom conditional formatting multiple conditions

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))

Upvotes: 0

Views: 3046

Answers (1)

Ed Nelson
Ed Nelson

Reputation: 10259

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")

Upvotes: 1

Related Questions