linked formatting? link color of cells on two tabs

[jason gers]

i have two tabs on one worksheet -- one neatly formatted template page
pulls data from a sloppy "raw data" tab.

the problem is this -- the "raw data" tab has numbers that the system
outputs colored green or red for statistical significance. is there a
way to pull the color-formatting off the raw data tab onto the
template tab? Right now I am doing this all manually on a dozen
reports and it takes forever. There has got to be some way to
systematize this to save time.

Thanks
Jason G

 

[Zaidy036]

i have two tabs on one worksheet -- one neatly formatted template page
pulls data from a sloppy "raw data" tab.

the problem is this -- the "raw data" tab has numbers that the system
outputs colored green or red for statistical significance. is there a
way to pull the color-formatting off the raw data tab onto the
template tab? Right now I am doing this all manually on a dozen
reports and it takes forever. There has got to be some way to
systematize this to save time.

Thanks
Jason G

free add-in ASAP Utilities has functions that work on cell color

Eric