Select the I cell, and use Format / Conditional Formatting.... then select the Formula Is option,
and use the formula (assuming your cell is in Row 2)

=F2=(E2*1.0125)

or

=F2=(E2*1.0125)

or

=F2(E2*1.0125)

(Which formula you should use depends on your definiton of "is more than" ;-) )

and set the fill to black.

HTH,
Bernie
MS Excel MVP


"miller" wrote in message
...
I need help with creating a formula for the following:

If cell F is 1.25% more than cell E than turn cell I black.

Please help