changing font color based on change actual number in a table

[QUOTE=pb71;2336567]Check the formula in your defined name TemplateAddress:



i try but i am getting error ..maybe i try to not selected table first?
or becouse i write this:
=INDIRECT("'Original'!"&ADDRESS(ROW(),COLUMN())) in Refers to box ???????







Can you write t ome ...steps to create a name define?





First step is to selecting all value, all table?

Then i go to Format-Name-Define?

Name: TemplateAddress

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