Multiple conditional formats met

[mtt]

I want to set a conditional format so that the formatting will show only if
BOTH conditions are met. Condition 1: B5>20 Condition 2: B5>C5*1.5 I am
using XL 07.

 

[Barb Reinhardt]

Try this for the formula

AND(B5>20, B5>C5*1.5)

 

[mtt]

Awewsome! It worked. Thanks.

Try this for the formula

AND(B5>20, B5>C5*1.5)