Google Sheets Conditional formatting based on multiple conditions

0
votes

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.

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

This is what I am trying to do:

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")
1
google-sheetsgs-conditional-formatting
If this is google-sheets then why the Excel tag? – Scott Craner
I put google sheets but it said error and recommended excel so I changed it. – Tiffany Poche
Scott Craner any ideas of the formula? – Tiffany Poche
no, sorry, my expertise is in Excel and that formula should work in Excel. The only suggestion I would make is to make sure the dates in Column E are actual dates and not text that looks like dates. – Scott Craner

1 Answers

0
votes

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