Google表格基于多个条件的条件格式

我在我的上一家公司的Google表格中有一个电子表格，它根据我的资格条件突出显示了所有行。我不记得使用了什么条件格式。

I had 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.

我已经尝试了 = IFAND 和 = AND 函数以及其他函数。

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

这就是我想要做的：

This is what I am trying to do:

如果B列表示DTC和日期介于两个范围之间，我希望
突出显示。然后，我将有多个规则在日期和
字词中有所不同。

If column B says DTC and the dates are between two ranges I want it highlighted. Then I will have multiple rules that vary in dates and words.

这是我试过的最后一个公式。

This is the last formula I tried.

=AND($B2="DTC",$E2>="10/1/2017",$E2<="10/6/2018")