ExcelBanter - Multiple conditional formats met

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Multiple conditional formats met (https://www.excelbanter.com/excel-discussion-misc-queries/199782-multiple-conditional-formats-met.html)

mtt

Multiple conditional formats met

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.

Barb Reinhardt

Multiple conditional formats met

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.

mtt

Multiple conditional formats met

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.

All times are GMT +1. The time now is 12:04 AM.