Google表格基于多个条件的条件格式 [英] Google Sheets Conditional formatting based on multiple conditions

问题描述

我在我的上一家公司的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")

推荐答案

引号之间的日期将被视为字符串，而不是日期。改为使用 DATE（年，月，日）。

If you enconclose dates between quotations marks they will be treated as strings, not as dates. Used DATE(year,month,day) instead.

这篇关于Google表格基于多个条件的条件格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！