Andreamary
asked on
Conditional formatting based on multiple criteria
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.
Thanks,
Andrea
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.
Thanks,
Andrea
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for providing solutions so quickly...much appreciated! Sorry about forgetting the attachment...! Given that both responses came in within a couple of minutes of each other, I've shared the points. I identified the first solution as the best one, since it was first and it included the "$" in the formula which was beneficial.
Cheers,
Andrea
Cheers,
Andrea
-Glenn
EE-Q-28521167.xlsx