Hi

I have a spreadsheet where 1 cell is conditionally formatted based on the
text status of 3 other cells, the text options being good, bad or average.
The criteria is a follows:

If more than 2 goods the cell = green
if more than 2 bads the cell = red
If more that 2 averages or a mixture of all three the cell = amber

I would be very grateful if you could give me any help on the formula
required?