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.
Bookmarks