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:
Conditional formatting, using a formula to determine cell format