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?
|