| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format cell containing hyperlink
I have been trying to set conditional formatting to color cell A158 (which
contains a hyperlink to a bookmarked area in a Word document) black if cell B5 is non blank, and white (so no text appears) if cell B5 is blank. I am using these two conditional formats: Formula is =$B$5<"" (text color is black) Formula is =$B$5="" (text color is white) I can get this to work on other cells, but not my cell containing the hyperlink. Is this possible? Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
| Conditional format - another cell | Excel Worksheet Functions | |||
| Hyperlink Cell Format | Excel Discussion (Misc queries) | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| How to remove Hyperlink without changing cell format? | Excel Worksheet Functions | |||
Threaded Mode
