Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell colours moving with a row
I want to be able to have the colour of a cell move with a row from one
worksheet to another, what do I need to add to our current formula to achieve this?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell colours moving with a row
If you are moving the row by cutting & pasting it from one sheet to another,
the cells' colors will move with the cells. If you are pulling values from one sheet into another sheet using formulas, you will have to manually apply the color formatting to the second sheet. Formulas only return values; they can't change cell colors or borders. If the colors on the first sheet are the result of conditional formatting, apply the same conditional formatting on the second sheet. Or, you could select the row on the first sheet, then use Format Painter to format the row identically on the second sheet. Hope this helps, Hutch "Kingdazza" wrote: I want to be able to have the colour of a cell move with a row from one worksheet to another, what do I need to add to our current formula to achieve this?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting cell colours | Excel Worksheet Functions | |||
Cell Colours | Excel Discussion (Misc queries) | |||
Cell colours not showing | Excel Discussion (Misc queries) | |||
Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
How to set different font colours in a cell? | Excel Worksheet Functions |