Conditional Formatting Formula

[Beckie_001]

Hi

I have hundreds of columns with a value from the list below. I want to highlight all the cells that end in 'E' red, 'D' green and 'S' purple. I was wondering if there was a formula for this to save me having to write 21 rules?

0 to 11 Months - E

0 to 11 Months - D

0 to 11 Months - S

8 to 20 Months - E

8 to 20 Months - D

8 to 20 Months - S

16 to 26 Months - E

16 to 26 Months - D

16 to 26 Months - S

22 to 36 Months - E

22 to 36 Months - D

22 to 36 Months - S

30 to 50 Months - E

30 to 50 Months - D

30 to 50 Months - S

40 to 60 Months - E

40 to 60 Months - D

40 to 60 Months - S

ELG - E

ELG - D

ELG - S Thanks Beckie

<colgroup><col style="width: 98pt; mso-width-source: userset; mso-width-alt: 4754;" width="130"> <tbody>
</tbody>

 

[Gilliam]

for the red conditional formatting:
=RIGHT(TRIM(A1),1)="E"

for the green conditional formatting:
=RIGHT(TRIM(A1),1)="D"

for the purple conditional formatting:
=RIGHT(TRIM(A1),1)="S"