To try out those you will have to select condition using formula within CF.
Follow the below steps

1. Select the cell/Range (say A1:A10). Please note that the cell reference
A1 mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the formulas

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Either try the below for text starting with 'S'
=LEFT(A1,1)="S"

OR for a 'S' anywhere in the text
=ISNUMBER(SEARCH("S",A1))

If this post helps click Yes
---------------
Jacob Skaria


"JohnPM" wrote:

I use three conditions in the active cell. Entry "A" returns yellow
background, Entry "O" returns green and entry "S" returns red. I would like
to get a RED return in all cases "S" is used in the active cell as in S1 or
S2 or S3 or S4 etc. Wildcard is apparently not an option in CF. Any neat
solutions?