Help with a formula

M

miller

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
 
B

Bernie Deitrick

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
 
B

Bob Phillips

Conditional formatting, Format>Conditional Formatting.

Change Condition 1 to Formula Is

Insert a formula of =F2>E2*1.0125

Click Format, Select the Pattern tab, and choose black

OK out
 
M

miller

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.
 
Top