I got the math to work but im still confused about turning cell "I" black if
that formula is true. you say set the fill to black? what does that mean. Im
using office 07.

"Bernie Deitrick" wrote:

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