Try again...
depending upon the target, and where the cells are. Assume the target is
100, and the target cells are A1:A100
Select A1:A100
Menu FormatConditional Formatting
Change condition to Formula Is
Add formula of =AND(A1=100-(100*15%),A1<=100+(100*15%))
Click format, select Pattern and choose a colour
OK
Add condition
repeat with a formula of =AND(A1=100-(100*20%),A1<=100+(100*20%))
OK out
--
HTH
RP
(remove nothere from the email address if mailing direct)
"KCi" wrote in message
...
I have a question about conditional formatting. How can I use one
condition
to say "make the cell yellow if the number being judged is 15-20 percent
below or 15-20 percent above the target"? I ask how can i use one because
there are two other conditions +- 15%. and +- 20%.
|