Cell font color

B

bbc1

I need a formula that will change the color of a font in
a cell if a particular value is inserted, cannot use
conditional formatting as have 8 conditions.
ie need cell to turn red if meets Ath, blue if Bel,
Yellow if Boo, green if Mait, etc this is for team
formatting and sorting.
 
Top