CODEWITHSUNDEEP
dategoogle-sheetsgoogle-sheets-formulacountinggs-conditional-formatting
Taylor D
Taylor D

Reputation: 1

Bigger than X but smaller than Y

I've been racking my brain on Google Spreadsheets to make my conditional format rule be greater than or equal to 14 and less than or equal to 20. The current code is this 

=AND(DAYS(TODAY(),DATEVALUE(F:F))>=14,D:D <> "Exiled Emperor",D:D <> "High Council", D:D <> "Dark Council",D:D <> "Darth", M:M <> "Honorary")

Upvotes: 0

Views: 122

Answers (1)

player0
player0

Reputation: 1

try:

=(DAYS(TODAY(), DATEVALUE(F:F))>=14)*
 (DAYS(TODAY(), DATEVALUE(F:F))<=21)*
 (NOT(REGEXMATCH(D:D, "Exiled Emperor|High Council|Dark Council|Darth")))*
 (M:M<>"Honorary")

Upvotes: 1

Related Questions