Trying to create conditional format cell

[Sky]

trying to automate a form. Have 1st part of what I want to do but don't know
how to do the rest. Example
Cell "C" = Cell A minus cell B . Now what I want to do is this: if Cell C is
10 percent less than Cell D then text is Red, Bold, Fill is yellow. is this
Possible? Not very good at math functions.

 

[Luke M]

select cell C2. Format - Conditional Format. Change first box to "Formula
is". In second box, input this:
=C2<0.9*D2
Click the format button, on text tab, select bold, and on pattern tab,
choose yellow.
Ok out.

(assuming you meant 10% less or more)

 

[boguslawasiak]

paste it to the formula into conditional formatting. My english is bad I
hope U will understand.
=C2<(D2-0,1*D2)

„Sky†pisze:

 

[Sky]

select cell C2. Format - Conditional Format. Change first box to "Formula
is". In second box, input this:
=C2<0.9*D2
Click the format button, on text tab, select bold, and on pattern tab,
choose yellow.
Ok out.

(assuming you meant 10% less or more)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

still a little confused. When you say format do you mean click on
conditional format tab or cell format . if conditional which tab next. Sorry
I need the Dummies version