Conditional Formatting
 

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.

Conditional Formatting
 

One way:

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

In article , WillW
wrote:

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.

Conditional Formatting
 

I also like the {} construct

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

"JE McGimpsey" wrote:

One way:

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

In article , WillW
wrote:

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.

Conditional Formatting
 

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

In article ,
Duke Carey wrote:

I also like the {} construct

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

"JE McGimpsey" wrote:

One way:

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