Thread: Can I use an if statement within the conditional formatting tool?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default 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?


Reply With QuoteReply With Quote