|Well, that's a bit clearer!|
I don't have 2007, but the concept is the same as in 2003. You need to base your formatting on the results of an IF statement. If the result is True, the pattern chosen will take effect.
I'll modify an example found at:
In Excel 2007:
1. Select J2
2. On the Ribbon, go to the Home tab and click Conditional Formatting
3. Click New Rule
4. Click Use a Formula to Determine Which Cells to Format
5. For the formula, enter
6. Click the Format button.
7. Select the fill format for Green
8. Click OK, click OK
Now, click New Rule but this time use:
=(IFG2>H2,TRUE,FALSE) and select the fill format for Red.
You should also think about what should happen if G2 = H2.