| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make a format to follow the cell
A1 contains 5 with red background.
If I type in another cell, "=A1" then how can I force the new cell to show the 5 in red background? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make a format to follow the cell
A formula can only return a result, not a format.
If that red background is the result of conditional formatting, however, you can apply the same CF rules to the destination cell to get the same effect. Hope this helps. Pete On Aug 18, 10:42*am, Darren wrote: A1 contains 5 with red background. If I type in another cell, "=A1" then how can I force the new cell to show the 5 in red background? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make a format to follow the cell
Thanks mate - so I guess I just have to keep writing macro after macro to get
over the short comings of Excel :-) "Pete_UK" wrote: A formula can only return a result, not a format. If that red background is the result of conditional formatting, however, you can apply the same CF rules to the destination cell to get the same effect. Hope this helps. Pete On Aug 18, 10:42 am, Darren wrote: A1 contains 5 with red background. If I type in another cell, "=A1" then how can I force the new cell to show the 5 in red background? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I make a format to follow the cell
It seems that way ...
Pete On Aug 18, 1:31*pm, Darren wrote: Thanks mate - so I guess I just have to keep writing macro after macro to get over the short comings of Excel :-) "Pete_UK" wrote: A formula can only return a result, not a format. If that red background is the result of conditional formatting, however, you can apply the same CF rules to the destination cell to get the same effect. Hope this helps. Pete On Aug 18, 10:42 am, Darren wrote: A1 contains 5 with red background. If I type in another cell, "=A1" then how can I force the new cell to show the 5 in red background?- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make the heading follow when scrolling? | Excel Worksheet Functions | |||
| how do i make a chart follow the active cell | Charts and Charting in Excel | |||
| make hyperlinks follow the copied sheet, not the original | Excel Discussion (Misc queries) | |||
| How do I make a row or information, follow as you scroll down..? | Excel Worksheet Functions | |||
| How do I make the fill color of a cell on one sheet follow the co. | Excel Worksheet Functions | |||
Linear Mode
