use of wildcards in conditional formatting

J

JohnPM

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

David Biddulph

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

Jacob Skaria

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
 
J

Jacob Skaria

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 Format>Conditional Formatting>

3. For Condition1>Select 'Formula Is' and enter the formulas

4. Click Format Button>Pattern and select your color (say Red)

5. Hit OK

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top