Working with AND / OR

Conditional Formatting in Google Sheets

Adam Steinfurth

Instructor

OR function

=OR(condition1,condition2)

Credits

• Less than 6

• Not a number

ISTEXT function

• Returns TRUE if value is text: "Cat", "Tree", "Truck"

• Returns FALSE if value is not text: 12, December 3 1976, 23.88

Finished formula

=OR(C2<6,ISTEXT(C2))

• Is the number of credits in C2 less than 6?

OR

• Does C2 have a "text" value?

Less than part-time formatted

AND function

=AND(condition1,condition2)

Full-time accounting students

Full-time accounting students

=AND(B2="Accounting",C2>=12)

Give it a shot!

Conditional Formatting in Google Sheets