Sure thing. You need a conditional formatting rule.
Not sure of your version of Excel, but if you're 2007 or higher then:
- Select cells F4:L4 (start from F4)
- Home Tab --> Conditional Formatting --> New Rule --> Use a formula to determine which cells to format --> Use the following formula
- =SUM($F$4:$L$4)>56
- Click "Format" --> Font --> Color --> Red
- Click OK --> OK
At this point it should turn red every time the aggregate in the cells exceeds 56
Hope this helps,
Bookmarks