Conditional Formatting

[Guest]

How do I enter the condition for "Formula is" if I want to base conditional
formatting on more than one valid value in a cell - i.e., if L$9 equals
either "Sat" or "Sun"?

My test for a single value works(=L$9="Sat"), but I can't seem to extend it
to more than one value without errors.

Thanks.

 

[JE McGimpsey]

One way:

=OR(L$9="Sat",L$9="Sun")

 

[Guest]

I also like the {} construct

=or(l$9={"Sat","Sun"})

 

[JE McGimpsey]

I do too, but it only works with literals, where separate arguments can
include references, so I usually don't use it in examples.