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