Can I use an if statement within the conditional formatting tool?
 

I am wanting to say if column A = and column b is <95% highlight column B.

Is this feasable?

Can I use an if statement within the conditional formatting tool?
 

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

"Jen" wrote in message
...
I am wanting to say if column A = and column b is <95% highlight column B.

Is this feasable?

Can I use an if statement within the conditional formatting tool?
 

You can but it's not necessary:

I am wanting to say if column A = and column b is <95% highlight column B.

Do you mean if column A = 95% and column B < 95% ?

=AND(A1=0.95,ISNUMBER(B1),B1<0.95)

Biff

"Jen" wrote in message
...
I am wanting to say if column A = and column b is <95% highlight column B.

Is this feasable?