2 CONDITIONS FOR CONDITIONAL FORMAT?
 

I'm trying to format cells to a colour if they contain either an 'L' or an
'S'.

I've already used up my quota of three conditional formats so I need to
combine these into just one.

I've tried

="L" OR "S"

and

="L" OR = "S"

Am I on the wrong track or is this possible?

2 CONDITIONS FOR CONDITIONAL FORMAT?
 

How about =OR(="L",="S")?

Charles

merlin wrote:
I'm trying to format cells to a colour if they contain either an 'L' or an
'S'.

I've already used up my quota of three conditional formats so I need to
combine these into just one.

I've tried

="L" OR "S"

and

="L" OR = "S"

Am I on the wrong track or is this possible?

2 CONDITIONS FOR CONDITIONAL FORMAT?
 

Whoops mod that just a little...
Change to formula is:
=OR(F3="L",F3="S")
Change "F3" to the first cell in your range

Charles Chickering

Die_Another_Day wrote:
How about =OR(="L",="S")?

Charles

merlin wrote:
I'm trying to format cells to a colour if they contain either an 'L' or an
'S'.

I've already used up my quota of three conditional formats so I need to
combine these into just one.

I've tried

="L" OR "S"

and

="L" OR = "S"

Am I on the wrong track or is this possible?

2 CONDITIONS FOR CONDITIONAL FORMAT?
 

Perfect. I don't pretend to understand the syntax in the logic (one of my
weak areas) but it works a treat.

Nearly forgot to change the 'formula=' box!

"Die_Another_Day" wrote in message
oups.com...
Whoops mod that just a little...
Change to formula is:
=OR(F3="L",F3="S")
Change "F3" to the first cell in your range

Charles Chickering

Die_Another_Day wrote:
How about =OR(="L",="S")?

Charles

merlin wrote:
I'm trying to format cells to a colour if they contain either an 'L' or
an
'S'.

I've already used up my quota of three conditional formats so I need to
combine these into just one.

I've tried

="L" OR "S"

and

="L" OR = "S"

Am I on the wrong track or is this possible?