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