Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fill colour a cell from the linked cell
How do i get a cell to use the colour from the cell it is linked to.
Cell A1 is reading the date from cell D1 If i was to add a fill colour to cell D1 is there a way that cell A1 would automatically change to the same colour? |
#2
|
|||
|
|||
Hi Stephen,
It is not part of Excel, and automatically implies a macro. If the color in D1 is from Conditional Formatting you would use the same exact formula that you used for column D, simply select both columns when doing the C.F. If you were coloring cells in D using a change Event macro, you would include column A at the same time. You can manually copy the formatting and then use Edit, Paste Special, formats to paste into column A. A color change will not trigger an Event macro, so hopefully you were using Conditional Formatting. (limit of 3 colors + default colorations) -- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Stephen C" <Stephen wrote in message ... How do i get a cell to use the colour from the cell it is linked to. Cell A1 is reading the date from cell D1 If i was to add a fill colour to cell D1 is there a way that cell A1 would automatically change to the same colour? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I replace the path of the linked spreadsheet in a cell? | Excel Worksheet Functions | |||
spinner linked cell problem | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Can I fill colour in a excel cell from a return from an "IF" test. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |