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?

Hi

Try this formula:

=IF(ISERROR(SEARCH("s",A2;1)),,1)0

Regards,
Per

"JohnPM" skrev i meddelelsen
...
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?

=ISNUMBER(FIND("S",A1)) if you want it case-sensitive
=ISNUMBER(SEARCH("S",A1)) case-insensitive.
--
David Biddulph

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?

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?

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?

Try this:

=LEFT(A1)="S"

--
Biff
Microsoft Excel MVP


"JohnPM" wrote in message
...
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?