Adding cell labels to multiple single cells

[Carr]

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

 

[B. R.Ramachandran]

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

 

[Sheeloo]

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?

 

[Gord Dibben]

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

Insert>Name>Create

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

 

[Carr]

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(cost2>600)" where
"cost2"='sheet1'!d2.

Cheers
Chris

 

[Carr]

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]

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

 

[Gord Dibben]

OK

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


Gord