I am wanting to say if column A = and column b is <95% highlight column B. Is this feasable?
J Jen Oct 19, 2006 #1 I am wanting to say if column A = and column b is <95% highlight column B. Is this feasable?
P PCLIVE Oct 19, 2006 #2 I'm not sure what your A should equal. Use this formula in your conditional formatting line. Change dropdown to "Formula Is". =AND(A1=25,B1>.95) Note: In my example, 25 is the first condition for A =. Adjust as necessary. HTH, Paul
I'm not sure what your A should equal. Use this formula in your conditional formatting line. Change dropdown to "Formula Is". =AND(A1=25,B1>.95) Note: In my example, 25 is the first condition for A =. Adjust as necessary. HTH, Paul
B Biff Oct 19, 2006 #3 You can but it's not necessary: I am wanting to say if column A = and column b is <95% highlight column B. Click to expand... Do you mean if column A = 95% and column B < 95% ? =AND(A1=0.95,ISNUMBER(B1),B1<0.95) Biff
You can but it's not necessary: I am wanting to say if column A = and column b is <95% highlight column B. Click to expand... Do you mean if column A = 95% and column B < 95% ? =AND(A1=0.95,ISNUMBER(B1),B1<0.95) Biff
