Bring forward conditional formatted characteristics
 

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

Bring forward conditional formatted characteristics
 

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

Bring forward conditional formatted characteristics
 

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

Bring forward conditional formatted characteristics
 

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