How do i get about 8 items to change colour depending on wording, i can only conditional format 3 items, is there another way we can do this maybe using if formulas?

Oh and depending on colour i may need to change the colour of the text

Can this be done?

Thanks

FBF