I've been voluntold to create a spreadsheet in work. I've got it pretty squared away but am stuck on a formula to make it do one more thing. Basically I have a series of criteria that give a displayed result of red, amber or green (with that text in the cell). I then have a summary cell for the row and I want it to automatically show red, green or amber based on the following: If all cells are green return the result green. If any cell is red then return the result red. If no cells are red but any of the cells are amber then return the result amber. Any help would be appreciated.