| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to get contents of cell linked through IF function.
Hi,
I am using an IF function and I want the result to bring the formats of the cell as well as the content. For example, IF(A1=1,B1,B2) where B1 and B2 are cells that have different contents and formats (colors,fonts,etc.). Is this possible? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trying to get contents of cell linked through IF function.
Hi,
I don't think you can use a function to do anything else except return a formula. However, in your example, you could perhaps use conditional formatting. In the formula cell, open the CF window, select Formula Is, then: Condition 1 =B1 and select format conditions identical to B1 Condition 2 =B2 and select format conditions identical to B2 Regards - Dave. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trying to get contents of cell linked through IF function.
Dave,
That worked. Thanks!!! "Dave" wrote: Hi, I don't think you can use a function to do anything else except return a formula. However, in your example, you could perhaps use conditional formatting. In the formula cell, open the CF window, select Formula Is, then: Condition 1 =B1 and select format conditions identical to B1 Condition 2 =B2 and select format conditions identical to B2 Regards - Dave. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use of the Contents of a cell as a worksheet name in a function | Excel Worksheet Functions | |||
| Excel 2003 cell contents truncated when linked into Word? | Links and Linking in Excel | |||
| linked cell contents not autofitting row height | Excel Discussion (Misc queries) | |||
| Contents of adjacent cell from a function | Excel Worksheet Functions | |||
| Function to operate on ink linked to cell | Excel Worksheet Functions | |||
Linear Mode
