Trying to create conditional format cell

  • Thread starter Thread starter Sky
  • Start date Start date
S

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

„Sky†pisze:
 
Luke M said:
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!*
Click to expand...
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 :)
 
Back
Top