Conditional Format IF

[Zedved]

I need to color a cell if a range is greater than a value.

If((sum(D32:F32))/64.5)>.8 then color E32 orange.

Please I need it as a forumla to put in the conditional formatting window.

Pathetic I know, but I found my own answer: =(SUM(D32:F32)/64.5)>0.8

 

[VoG]

Simpler

=(D32+F32)/64.5>0.8

 

[Zedved]

VoG - that sums two cells, but I need to sum a range of three cells.
Thank you for your reply.

 

[VoG]

Oops!