Conditional formatting

[P Beardshall]

Is it possible to conditional format for specific terms within a cell.

e.g. the addition a letter or letters to a number will change the colour of
the cell.

1A = Red
10B = Yellow
100AB = orange.

 

[Stefi]

E.g.
Formula for conditions:
=LEN(cellref)=2

1A = Red =LEN(cellref)=3
10B = Yellow =LEN(cellref)>3
100AB = orange.

Regards,
Stefi

 

[Teethless mama]

Highlight your range
Conditional Formatting
Condition 1: =A1="1A" (Format as red)
Condition 2: =A1="10B" (Format as Yellow)
Condition 3: =A1="100AB" (Fomat as Orange)

 

[daddylonglegs]

Is it just the letter that determines the colour, e.g. any cell ending "AB"
should be orange?

If so use these conditions

1 =RIGHT(A1,2)="AB"
orange

2 =RIGHT(A1)="B"
yellow

3 =RIGHT(A1)="A"
red