contitional format for many to many 1

[jslmvl]

Hi,

I know hwo to set a conditional format for a cell, say
for B1, set its color to be red if A1=1

However, I don't know how to set many cells, like
for B1, set its color to be red if A1=1
for B2, set its color to be red if A2=1
for B3, set its color to be red if A3=1
.....

Can you help?

 

[jslmvl]

Sorry, my question is about Excel

 

[jslmvl]

OK, I find:
just do paste special formats!

Thank you.

 

[JPaules]

for B1, set its color to be red if A1=1
for B2, set its color to be red if A2=1
for B3, set its color to be red if A3=1

I just did something like this. Using your example, what do you want B1 to be if A1 does not equal 1?

--
JP

 

[jslmvl]

If A1 does not equal 1, B1 will be the default color.

 

[Lilliabeth]

Instead of 'Cell value is', choose 'Formula Is'
=$A1=1

--Lilliabeth

 

[jslmvl]

Lilliabeth,

You are right. Thanks a lot!