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

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

Conditional formatting, FormatConditional Formatting.

Change Condition 1 to Formula Is

Insert a formula of =F2E2*1.0125

Click Format, Select the Pattern tab, and choose black

OK out

--
__________________________________
HTH

Bob

"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

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