Basic Conditional Formatting

Very basic formatting question. I'm trying to highlight a certain cell or row based upon a rule (comparison of the sum of two cells to another cell).
Trying format a row's color base upon a simple comparison (if,then) in that row. Example:

=if F10+G10>H10, highlight or fill the entire row red

I'm using 2007 right now. I can't get the conditional formatting tool to do this with a rule "use a formula to determine which cells to format." Not sure what formula to put into the box when creating this rule.
(Also, I am clicking the format button and choosing a fill of red, but what cells or rows is it setting this rule for (what cells or rows will be filled red))?
Ideas? Thank you so very much!

Thanks Jeffrey!
So the box (format values where this formula is true) is the "IF", and Format Preview is the "Then."

How would I pull that formula down, to analyze each row, and return that format if that row's formula is true (F+G > H)?
Would each row need its own rule?

Thanks Jeffrey!
So the box (format values where this formula is true) is the "IF", and Format Preview is the "Then."

How would I pull that formula down, to analyze each row, and return that format if that row's formula is true (F+G > H)?
Would each row need its own rule?

Worked perfect! Thanks! Had to tweek row number in formula (to what row I started my highlight range on (elsewise the highlighted rows were off)).
Thanks a million Jeffrey!

Tremendous help! Thanks again. I'm not the best at conditional formatting (as you can see), but am learning it and it seems to be like other excel functions; logic, anchor points, etc.
One last step:

I have 2 tabs/sheets, a data input tab (lots of messy data) and a Viewable tab (output for report, very clean and easy to read). How would I get the formatting of the row (in the Data input tab) to carry over to the viewable tab? I'm using a VLookup on the viewable tab, to carry over only the needed rows from the hefty, messy data tab. Thoughts???

It's a simple little workbook. Can I upload it?

Here is the small file. 4 sheets in this workbook. the right two are the data input. The left two is the cleaner output. I need to protect some cells, etc. Am I on the right track with this? The conditional is highlighting the row red if F & G exceed balance in savings.
Thanks a million!

if the sum of them exceed (then that customer doesn't have enough money in their savings deposit, so we want a flag raised to us). I guess one could just set up conditionals on the output worksheets, but then it gets messy tying some things to input sheet and others to output sheet, etc....

I guess that works. I just try to steer clear of getting too many formulas mixed into the master sheets, as we use the masters for our output and run them once a week.
If we tracking this on a weekly basis (the prior weeks ending balance becomes next weeks beginning balance) how would you suggest setting it up?:
-Create a new workbook for each week?
or
-Keep the same workbook, just create more tabs (sheets) for each week?

I'm thinking I should start using Access to build a database of activity for each customer...

Thanks for you help Jeffrey. It's much appreciated!

The conditional doesn't like the vlookup. It isn't recognizing the values it is producing, so it won't highlight/fill red if over the amount that is specified... any thoughts?