Conditional Format based on Sum

[NISMOJim]

Hello,

I don't usually do much in Excel, but I have been asked to work on a spreadsheet, and I am lost.
I would like to format the background color of a cell based on the sum of a range of cells.

A2 background color = Green if A3 through A10 sum is 85 or greater
AND A2 background color = Red if A3 through A10 sum is less than 35
OTHERWISE A2 background color = Yellow (if A3 through A10 is between 35 & 84)

Is this even possible? If so, how would I write the formula to put in cell A2?
Any & all help is appreciated.

[JohnTopley]

Select A2 set background to YELLOW

Select Conditional Formatting ..Use a formula ....>> =SUM($A$3:$A$10)>=85 ..Format..Fill>>GREEN

Select Conditional Formatting ..Use a formula ....>> =SUM($A$3:$A$10)<35 ..Format..Fill>>RED

[bebo021999]

2nd CF from John Topley should be: ...<35

[JohnTopley]

@bebo: thank you .... copied formula and forgot to change!

[NISMOJim]

This works perfectly, thank you very much.