Conditional formatting, using a formula to determine cell format [Closed]

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:


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!