How to use AND in Google Sheets w multiple criteria

by karendibee   Last Updated March 12, 2018 20:03 PM

What is the proper syntax for using "AND", when creating a custom formula in Google Sheets? (The formula applies to a format I set in the Conditional Formatting interface.)

H2:H2000 is greater than Today AND G2:G2000 is empty

How do I properly use AND in this case?

Related Questions

Conditional If Formatting Based on Two Columns

Updated February 04, 2018 22:03 PM

Conditional Formating in Google Sheets

Updated April 07, 2018 20:03 PM