conditional format question

[Harvey Waxman]

When I create a conditional format to change the background color of a
cell depending on the value in an adjacent cell I can't seem to copy
only that conditional format to other cells.

I don't see how I can create a conditional format for more than one cell
at a time either and there are 11000 cells.

I've examined the Help file with no success. I'm using Office X.

Any help?

 

[JE McGimpsey]

When I create a conditional format to change the background color of a
cell depending on the value in an adjacent cell I can't seem to copy
only that conditional format to other cells.

I don't see how I can create a conditional format for more than one cell
at a time either and there are 11000 cells.

I've examined the Help file with no success. I'm using Office X.

It's very likely possible, but it's hard to tell without more detail.

When you apply CF to multiple cells using relative references (e.g., A1,
vs an absolute reference like $A$1), XL will automatically change the
references. You can also use mixed references (e.g., $A1 or A$1), too.

 

[Harvey Waxman]

It's very likely possible, but it's hard to tell without more detail.

When you apply CF to multiple cells using relative references (e.g., A1,
vs an absolute reference like $A$1), XL will automatically change the
references. You can also use mixed references (e.g., $A1 or A$1), too.

What would the formula look like to CF each cell, say B1 through B50
depending on adjacent cells so if A2 is not empty B2 has the format.
As I said, I can do this one at a time. EG. =$A$2<>""

The cells already have data in them which I don't want to lose.

 

[JE McGimpsey]

What would the formula look like to CF each cell, say B1 through B50
depending on adjacent cells so if A2 is not empty B2 has the format.
As I said, I can do this one at a time. EG. =$A$2<>""

The cells already have data in them which I don't want to lose.

Use relative addressing. Select B1:B50 with B1 the active cell. Enter
the CF:

Formula is =A1<>""

XL will adjust the cell references.

 

[Carl Witthoft]

What would the formula look like to CF each cell, say B1 through B50
depending on adjacent cells so if A2 is not empty B2 has the format.
As I said, I can do this one at a time. EG. =$A$2<>""

The cells already have data in them which I don't want to lose.

There's your problem: the formula you started out with is absolute.
Edit it so it reads =A2<>""

Then select the cell, click the paintbrush (format copier), and select
the cells you want to copy the formatting into.

 

[Harvey Waxman]

What would the formula look like to CF each cell, say B1 through B50
depending on adjacent cells so if A2 is not empty B2 has the format.
As I said, I can do this one at a time. EG. =$A$2<>""

The cells already have data in them which I don't want to lose.

There's your problem: the formula you started out with is absolute.
Edit it so it reads =A2<>""

Then select the cell, click the paintbrush (format copier), and select
the cells you want to copy the formatting into.[/QUOTE]

Thank you both. I was letting Excel enter the formula by clicking on
the reference cell which adds the absolute references. I wonder why.