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