Excel 2007 : Conditional Formatting rows based on a cell

Hi all,

I just wanted to know if it was possible to conditional format and entire row based on 1 of it's cells. e.g. I have a table with 3 columns (total, positive, negative). I want to format the rows of this column based on the overall percentages in the Total Column (i.e. if the total column is greater than 5% of the overall Total then the row should have no fill). So row A has a total at 10, positive 4, negative 6. Row A should then all be filled.

Hope that a) makes sense and b) can be done. If it is posible how do I do it??

Thanks