| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link format along with contents of another cell
Say the formula in cell C1 is simply =A1. Is it possible to also link the
format of cell A1 to cell C1 so that if A1 is filled red, C1 will also be filled red? The shading in A1 is not based on cell contents so I can't figure out if it can be done with conditional formatting. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link format along with contents of another cell
You can NOT link formats through a formula provided by Excel...
To achieve this you will have to develop an User Defined Function and use that ------------------------------------ Pl. click ''''Yes'''' if this was helpful... "Claudia" wrote: Say the formula in cell C1 is simply =A1. Is it possible to also link the format of cell A1 to cell C1 so that if A1 is filled red, C1 will also be filled red? The shading in A1 is not based on cell contents so I can't figure out if it can be done with conditional formatting. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cell contents as MM | Excel Worksheet Functions | |||
| Custom Header - poss to link to contents of cell? | Excel Discussion (Misc queries) | |||
| Link page header with cell contents | Excel Worksheet Functions | |||
| All of contents in cell don't link | Excel Discussion (Misc queries) | |||
| Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
Linear Mode
