changing font color based on change actual number in a table

**pb71** · 07-03-2010, 09:59 AM

Excel 2003:

Select Insert - Name - Define

In the Names in workbook box, type TemplateAddress

In the Refers to box, type the following, and then click OK:

=INDIRECT("'Original'!"&ADDRESS(ROW(),COLUMN()))

(or whatever your reference worksheet is called - mine is named Original)

Excel 2007:

Formulas - Define Name

**petri** · 07-03-2010, 10:13 AM

Originally Posted by pb71

Excel 2003:

Select Insert - Name - Define

In the Names in workbook box, type TemplateAddress

In the Refers to box, type the following, and then click OK:

=INDIRECT("'Original'!"&ADDRESS(ROW(),COLUMN()))

(or whatever your reference worksheet is called - mine is named Original)

Excel 2007:

Formulas - Define Name

It is necesary to use two sheets? i cant work only on one sheet? Can you write to me each step please ?