Conditional format cell containing hyperlink

[JStiehl]

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.

 

[Bernard Liengme]

Select the cell with the hyperlink
Open the Format dialog
Click the box "Normal font"
This removes the blue/red formatting of the link
Worked for me in Excel 2003 and 2007
best wishes

 

[JStiehl]

Thanks so much! I appreciate your help.

Select the cell with the hyperlink
Open the Format dialog
Click the box "Normal font"
This removes the blue/red formatting of the link
Worked for me in Excel 2003 and 2007
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email