# Excel - Conditional Formatting using formula

• 10th June 2009, 02:08 PM
park_bench
Excel - Conditional Formatting using formula
Hello,

Is there a formula to use in conditional formatting that would do the following.

If 'B1' is between 0.01% and 20% the value of 'A1' = condition 1

ELSE IF 'B1' is between 20.01% and 75% the value of 'A1' = condition 2

ELSE IF 'B1' is over 75% the value of 'A1' = condition 3

Thanks,

Ben
• 10th June 2009, 03:25 PM
SYNACK
Not exactly what you asked for but the logic pattern for this problem is:
Code:

=IF(AND((B1<(0.2*A1)),(B1>(0.01*A1))),"Condition 1",IF(AND((B1>(0.2*A1)),(B1<(0.75*A1))),"condition 2",IF((B1>(0.75*A1)),"condition 3","no")))
using built in cell formulas, not sure if you can do it in 2k3 with conditional formatting as I am on 2k7 here. You can do it by formula in 2k7 which would require you to break it up into each stage and make a rule for each individual set of conditions

Edit: Never mind my convoluded answer, here is a tutorial:
http://blogs.techrepublic.com.com/msoffice/?p=831