You could use Conditional Formatting. Given the layout from post # 1, A1:E5, select A2:A5, click Conditional Formatting > New Rule > Use a formula > and enter:
=MAX(MMULT(TRANSPOSE(ROW($A$2:$A$5)^0),$C$2:$E$5*($A$2:$A$5=A2)))>30
click Format... and choose a fill color. You'll need to change the selection range as well as the ranges in the formula to match your sheet. You can extend the ranges both vertically and horizontally past your table to allow room for expansion. Or you can insert a row (or column) at the end, and the formula will adapt to include it.
I'm not sure how well this will scale. With larger ranges, it might start to bog down your sheet.