Conditional formatting, using a formula to determine cell format

Lanz - Jun 1, 2016 at 10:35 AM
Excel 2010

Hi, I need to make a spreadsheet and I want to use a BRAG rating to do so. To do this I want to type BLUE, RED, AMBER, GREEN into a cell and for all the cells in that row to change to the colour selected.

I have this sorted in another spreadsheet but it wont work on this one?

These are my formulas: