Bring forward conditional formatted characteristics

[Guest]

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

 

[Frank Kabel]

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

 

[Guest]

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

 

[Dave Peterson]

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.