brharrii,
I think what you're looking for is conditional formatting.
Attached is an example workbook based on the criteria you described.
On cell G4, I have applied the following conditional formatting rule:
G2 is the SNetwt, D2 is the RNetwt. So G2/D2 is the percentage of Snetwt/RNetwt. To get how much of a difference it is, take the absolute value (the ABS function) and subtract the result from 1. Now compare it to your x%. I assumed x% to be 5%, which is why if the % difference is > .05 (5%) then it applies the conditional formatting. I set the formatting to simply color the font text red.
To get to conditional formatting in excel 2007 and 2010, go to the Home tab on the ribbon -> Condtional Formatting -> Manage Rules. Make sure you have cell G2 selected when you do that, or select "This Worksheet" to show formatting rules for.
Bookmarks