Conditional Formatting various colums at once
 

Hi, I would like to add a Conditional Formatting to various colums at once.
Example if A1B1 make cells C1, D1 and F1 red,
Please advise

Conditional Formatting various colums at once
 

Select C1, D1 and F1 and use a formula of

=$A1$B1

--
__________________________________
HTH

Bob

"Compare Values" wrote in message
...
Hi, I would like to add a Conditional Formatting to various colums at
once.
Example if A1B1 make cells C1, D1 and F1 red,
Please advise

Conditional Formatting various colums at once
 

Thank you Bob but it did not work. I selected C, d and F at once an I typed
the below formula but nothing happens

"Bob Phillips" wrote:

Select C1, D1 and F1 and use a formula of

=$A1$B1

--
__________________________________
HTH

Bob

"Compare Values" wrote in message
...
Hi, I would like to add a Conditional Formatting to various colums at
once.
Example if A1B1 make cells C1, D1 and F1 red,
Please advise

Conditional Formatting various colums at once
 

Are you typing the =$A1$B1 formula in the Conditional Formatting dialog box
with Condition 1 set to Formula Is?

"Mary" wrote:

Thank you Bob but it did not work. I selected C, d and F at once an I typed
the below formula but nothing happens

"Bob Phillips" wrote:

Select C1, D1 and F1 and use a formula of

=$A1$B1

--
__________________________________
HTH

Bob

"Compare Values" wrote in message
...
Hi, I would like to add a Conditional Formatting to various colums at
once.
Example if A1B1 make cells C1, D1 and F1 red,
Please advise