| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for text and if correct bring forward a number | Excel Discussion (Misc queries) | |||
| Bring Forward Balances and Formulas in a Spreadsheet | Excel Worksheet Functions | |||
| How can I bring forward formats with Vlookup? | Excel Worksheet Functions | |||
| How do I bring hyperlinks forward using lookup? | Excel Worksheet Functions | |||
| how do I bring balances forward in Excel | Excel Worksheet Functions | |||
![Phil Hageman[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
