Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting a hyperlink into a conditionally formatted cell, Excel 2
I have a cell that is conditionally formatted. It references another cell and
the format (font and fill color) is dependent on the value of the referenced cell. I want that conditionally formatted cell to be a hyperlink, but I don't want to use the hyperlink's format (blue underlined and purple underlined font), I want it to retain the conditional formatting. It keeps the correct fill color, but the font goes to Hyperlink defaults. The font color needs to stay conditional. Can anyone help me? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting a hyperlink into a conditionally formatted cell, Excel 2
In xl2003 menus:
Select the cell Format|Cells|style and choose Normal Rawknee wrote: I have a cell that is conditionally formatted. It references another cell and the format (font and fill color) is dependent on the value of the referenced cell. I want that conditionally formatted cell to be a hyperlink, but I don't want to use the hyperlink's format (blue underlined and purple underlined font), I want it to retain the conditional formatting. It keeps the correct fill color, but the font goes to Hyperlink defaults. The font color needs to stay conditional. Can anyone help me? Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting a hyperlink into a conditionally formatted cell, Exc
That was easy enough. Thanks.
"Dave Peterson" wrote: In xl2003 menus: Select the cell Format|Cells|style and choose Normal Rawknee wrote: I have a cell that is conditionally formatted. It references another cell and the format (font and fill color) is dependent on the value of the referenced cell. I want that conditionally formatted cell to be a hyperlink, but I don't want to use the hyperlink's format (blue underlined and purple underlined font), I want it to retain the conditional formatting. It keeps the correct fill color, but the font goes to Hyperlink defaults. The font color needs to stay conditional. Can anyone help me? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionally Formatted Cells | Excel Discussion (Misc queries) | |||
Can you add the number of conditionally formatted cells?? | Excel Worksheet Functions | |||
Can I count conditionally formatted red cells in Excel 2000 | Excel Discussion (Misc queries) | |||
how do i concatenate conditionally formatted cells in excel | Excel Worksheet Functions | |||
Inserting images into excel conditionally | New Users to Excel |