november_whiskey
New Member
- Joined
- Nov 20, 2009
- Messages
- 6
I have six cells (C17, C21, C25, C29, C33, C37) where you can select Red, Amber or Green in each cell.
In another cell on the spreadsheet I want this cell to automatically tell me Red if one of the six cells has Red selected, Red if three of the six cells have Amber selected, Amber if 1 or 2 of the cells have Amber Selected and Green if the previous conditions do not apply.
If anyone can help I would be grateful.
In another cell on the spreadsheet I want this cell to automatically tell me Red if one of the six cells has Red selected, Red if three of the six cells have Amber selected, Amber if 1 or 2 of the cells have Amber Selected and Green if the previous conditions do not apply.
If anyone can help I would be grateful.