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

Report
-
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:

=$A5="G"
=$A4="A"
=$A3="R"
=$A2="B"

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!