At the moment I have a formula for =C3="Closed" which changes the column to a grey colour if the status column is marked as "Closed". I wish to add other values like "Cancelled" however my attempts have failed.
Original: =C3="Closed"
I have tried things like =C3="Closed","Cancelled" and =C3={"Closed","Cancelled"} to no avail.
It's probably something so easy but unfortunately I am missing it and I'm putting the wrong terms in Google or something as not even that helped!
Thank you
Bookmarks