Conditional formatting based on multiple criteria
Posted on 2014-09-18
I would like to implement conditional formatting in my Excel sheet as follows:
A2 cell background turns green if the following 2 criteria are met:
B2 is blank
C2 = "DOG 1" or "DOG 2" or "DOG 3" or "DOG 4" or "DOG 5"
Is is possible to do this with the Conditional Formatting feature, or is VBA required? I have attached a simple spreadsheet as an example of what I am looking for.