Color function

raej

I am working on a RACI log and trying to create a formula that turns the selections Green, Orange, Blue and Grey. I used rules to do this but not the best approach.

Paul Newcome

Conditional Formatting is the only way to get the cell fills to change color based on the input.