hi my question is

1) In an internal examination we have 8 questions and marks for each question is 5, which will be 40 marks.

2) the student has to answer 5 questions which will lead to 25 marks, but some students answer more than 5 and i have written the formula to consider only 5 questions and the formula is **"SUMPRODUCT(LARGE((F9:M9>=0)*F9:M9,{1,2,3,4,5}))"**

3) my question is from **F9 to M9 only those questions(i.e cells)** which have higher marks has to be highlighted with a colour automatically . how to do this

plz reply