Conditional formatting
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)
"P Beardshall" wrote:
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.
|