Awewsome! It worked. Thanks.

"Barb Reinhardt" wrote:

Try this for the formula

AND(B520, B5C5*1.5)
--
HTH,
Barb Reinhardt



"mtt" wrote:

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