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


Reply With QuoteReply With Quote