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.

Conditional format cell containing hyperlink
 

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


"JStiehl" wrote in message
...
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.

Conditional format cell containing hyperlink
 

Thanks so much! I appreciate your help.

"Bernard Liengme" wrote:

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


"JStiehl" wrote in message
...
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.