Hi, can anyone here help me?... I'm trying to apply multiple conditions to a formula and have attached a screen shot for reference.

Capture.JPG

The spreadsheet displays scores from a surf contest... The first thing I want to do is highlight the top 2 scores in a range eg. D8 to O8. In this particular range the second highest score appears twice and therefore 3 cells are highlighted... I'd like to highlight a max of 2 cells in that range and only count the duplicate score which appeared first in the row. However if the top score is duplicated, then both and only those cells need to highlighted. see row 32.

Another thing I'd like to do is with reference to row 34... If "INT" is present in a row the only the top 1 score is to be highlighted.

Lastly... I cell B6 I'd like to display the average of only the green coloured cells in the range D7 to O9.

Any help would be hugely appreciated.