Multiple conditions in One rule of Conditional Formatting

[tanmayjajoo]

Hello All

I'm using MS Excel 2010 and have a query on conditional formatting.
I have a worksheet, for which I want to set a conditional formatting rule obeying the following conditions-
-find minimum value between cell A2 and B2, format the cell C2 as
Cond 1- If minimum of the compared value in A2 and B2 is greater than equal to 80 but less than equal to 100, fill C2 as green.
Cond 2- If minimum of the compared value in A2 and B2 is greater then equal to 60 but less than equal to 79, fill C2 as orange.
Cond 1- If minimum of the compared value in A2 and B2 is greater then equal to 50 but less than equal to 59, fill C2 as yellow.
Cond 1- If minimum of the compared value in A2 and B2 is less than equal to 49, fill C2 as red.

Also, how to copy this rule for all the rows below.
Kindly refer the attached file for more.