Hi all,

I am needing to add a cell label to approx 700 cells but they will be
numbered differently (i.e. a2 = Cost2, a3 = Cost3). I need to do this to be
able to use conditional format from data on another worksheet. Is there an
easy way to do this? Or is there an easier way to do the conditional format?

Cheers
Chris

Hi,

In A2 enter the formula
="Cost"&ROW()
It will return "Cost2" in A2.
Fill down the column to as many cells as you want.

Regards,
B. R. Ramachandran

"Carr" wrote:

Hi all,

I am needing to add a cell label to approx 700 cells but they will be
numbered differently (i.e. a2 = Cost2, a3 = Cost3). I need to do this to be
able to use conditional format from data on another worksheet. Is there an
easy way to do this? Or is there an easier way to do the conditional format?

Cheers
Chris

You can also enter Cost2 in A2 and drag the cell corner down...

Need more information about conditional formatting? How are you planning to
use these labels?

"B. R.Ramachandran" wrote:

Hi,

In A2 enter the formula
="Cost"&ROW()
It will return "Cost2" in A2.
Fill down the column to as many cells as you want.

Regards,
B. R. Ramachandran

"Carr" wrote:

Hi all,

I am needing to add a cell label to approx 700 cells but they will be
numbered differently (i.e. a2 = Cost2, a3 = Cost3). I need to do this to be
able to use conditional format from data on another worksheet. Is there an
easy way to do this? Or is there an easier way to do the conditional format?

Cheers
Chris

You mean a cell "defined name"?

Insert a new column left of Column A

In A2 enter Cost2

Right-click on A2 and drag down to A700

Release and "Fill Series"

Select A2:B700

InsertNameCreate

Put a checkmark in Create names in "left column" and OK

Delete column A

Your original column A will now have a list of names.


Gord Dibben MS Excel MVP



On Tue, 17 Mar 2009 16:13:02 -0700, Carr
wrote:

Hi all,

I am needing to add a cell label to approx 700 cells but they will be
numbered differently (i.e. a2 = Cost2, a3 = Cost3). I need to do this to be
able to use conditional format from data on another worksheet. Is there an
easy way to do this? Or is there an easier way to do the conditional format?

Cheers
Chris

I am not referring to filling the cells themselves with text. I am referring
to the cell label reference, ie. cell a2 contains $32.32 and is labelled
Cost2. As mentioned, it may also be referred to as a defined name but I
haven't heard that.

I am trying to format a cell with a different colour text if the reference
cell on another worksheet is lower than 600. The only way I have been able
work out how to do this is by using a cell reference label as it won't let
you refer to another worksheet in conditional formatting. The formula I am
using in conditional formatting is "=not(cost2600)" where
"cost2"='sheet1'!d2.

Cheers
Chris


"Gord Dibben" wrote:

You mean a cell "defined name"?

Insert a new column left of Column A

In A2 enter Cost2

Right-click on A2 and drag down to A700

Release and "Fill Series"

Select A2:B700

InsertNameCreate

Put a checkmark in Create names in "left column" and OK

Delete column A

Your original column A will now have a list of names.


Gord Dibben MS Excel MVP



On Tue, 17 Mar 2009 16:13:02 -0700, Carr
wrote:

Hi all,

I am needing to add a cell label to approx 700 cells but they will be
numbered differently (i.e. a2 = Cost2, a3 = Cost3). I need to do this to be
able to use conditional format from data on another worksheet. Is there an
easy way to do this? Or is there an easier way to do the conditional format?

Cheers
Chris

My method does not fill the cells with text.

Please re-read the instructions.

What you're doing is creating names for each cell...........or "labels" if
that's what you want to call them.


Gord

On Tue, 17 Mar 2009 17:21:01 -0700, Carr
wrote:

I am not referring to filling the cells themselves with text. I am referring
to the cell label reference, ie. cell a2 contains $32.32 and is labelled
Cost2. As mentioned, it may also be referred to as a defined name but I
haven't heard that.

I am trying to format a cell with a different colour text if the reference
cell on another worksheet is lower than 600. The only way I have been able
work out how to do this is by using a cell reference label as it won't let
you refer to another worksheet in conditional formatting. The formula I am
using in conditional formatting is "=not(cost2600)" where
"cost2"='sheet1'!d2.

Cheers
Chris


"Gord Dibben" wrote:

You mean a cell "defined name"?

Insert a new column left of Column A

In A2 enter Cost2

Right-click on A2 and drag down to A700

Release and "Fill Series"

Select A2:B700

InsertNameCreate

Put a checkmark in Create names in "left column" and OK

Delete column A

Your original column A will now have a list of names.


Gord Dibben MS Excel MVP



On Tue, 17 Mar 2009 16:13:02 -0700, Carr
wrote:

Hi all,

I am needing to add a cell label to approx 700 cells but they will be
numbered differently (i.e. a2 = Cost2, a3 = Cost3). I need to do this to be
able to use conditional format from data on another worksheet. Is there an
easy way to do this? Or is there an easier way to do the conditional format?

Cheers
Chris

Thanks Gord, that is exactly what I needed. I misread it the first time but
it is perfect for what I need to do.

Many Thanks
Chris

"Gord Dibben" wrote:

You mean a cell "defined name"?

Insert a new column left of Column A

In A2 enter Cost2

Right-click on A2 and drag down to A700

Release and "Fill Series"

Select A2:B700

InsertNameCreate

Put a checkmark in Create names in "left column" and OK

Delete column A

Your original column A will now have a list of names.


Gord Dibben MS Excel MVP



On Tue, 17 Mar 2009 16:13:02 -0700, Carr
wrote:

Hi all,

I am needing to add a cell label to approx 700 cells but they will be
numbered differently (i.e. a2 = Cost2, a3 = Cost3). I need to do this to be
able to use conditional format from data on another worksheet. Is there an
easy way to do this? Or is there an easier way to do the conditional format?

Cheers
Chris

OK

Guess I should have read this post before replying to the other one.


Gord

On Tue, 17 Mar 2009 17:26:04 -0700, Carr
wrote:

Thanks Gord, that is exactly what I needed. I misread it the first time but
it is perfect for what I need to do.

Many Thanks
Chris

"Gord Dibben" wrote:

You mean a cell "defined name"?

Insert a new column left of Column A

In A2 enter Cost2

Right-click on A2 and drag down to A700

Release and "Fill Series"

Select A2:B700

InsertNameCreate

Put a checkmark in Create names in "left column" and OK

Delete column A

Your original column A will now have a list of names.


Gord Dibben MS Excel MVP



On Tue, 17 Mar 2009 16:13:02 -0700, Carr
wrote:

Hi all,

I am needing to add a cell label to approx 700 cells but they will be
numbered differently (i.e. a2 = Cost2, a3 = Cost3). I need to do this to be
able to use conditional format from data on another worksheet. Is there an
easy way to do this? Or is there an easier way to do the conditional format?

Cheers
Chris