use of wildcards in conditional formatting

  • Thread starter Thread starter JohnPM
  • Start date Start date
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?
 
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
 
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
 
Back
Top