View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JStiehl JStiehl is offline
external usenet poster
 
Posts: 35
Default 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.