Select the column to apply the formatting to and go to Format|Conditional Formatting

Select Formula is from 1st drop down and enter formula: =SUM($B$1:$B$3)>5 where B1:B3 is the range to check for Sum over 5.

Then click Format and choose your formatting.