Functions (builtin or homegrown in personal.xls) can't change formatting. They
return values.

If you recorded a macro when you did your edit|copy, edit|paste special|formats,
you'd see the code that could work in a Sub, though.



Phil Hageman wrote:

Thanks for your answer Frank. Would a function in the Personnal Workbook be
possible? Or is this a dead horse?

"Frank Kabel" wrote:

Hi
not possible with qa formula. You can try to copy the cell (also with
VBA code) But an automatic link is not possible

--
Regards
Frank Kabel
Frankfurt, Germany

"Phil Hageman" schrieb im
Newsbeitrag ...
In workbook €œHR A1€�, worksheet €œScorecard€�, cell AN6, is a percent
value that
is conditionally formatted.

In workbook €œDashboard€�, worksheet €œDashboard€�, cell W31, I want to
show the
AN6 value, along with the conditional formatting. How would this be
done?

Thanks,
Phil




--

Dave Peterson