View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Invisible Formatting ? or ... ?

I have some cells formatted in blue font & green background on my worksheet.
Is there a way for conditional formating, or some other way, to make them
invisible ? I need to provide most of the data on the worksheet to others,
but I don't want them to see those blue/green cells.
I know I could manually format them as no-fill with a white font, but I was
hoping to make it automatic, or even possibly with a macro. Any help or
assistance would be greatly appreciated.

Thanks,

Steve