Conditional Formatting

[casdaq]

I'm attempting to conditional format and running into some issues. Below is an example of what I am trying to accomplish..

Column A
8.06%

Column B
7.26%

If Column A is greater than Column B by .10% highlight in RED

Any ideas? BTW - Using Excel 2007

Thank you.

[daddylonglegs]

10% of what?

If you mean you want to format A1 if it's more than 110% of B1, so in this case as B1 is 7.26% A1 would be highlighted if A1 was more than 7.26%*1.1 =7.986%

...then try this formula in conditional formatting

=A1>B1*1.1