View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nikki
 
Posts: n/a
Default Conditional Formatting

Hi,

I was wondering if there was a way to find which cells have formula in them
and the high those that there is no formual. I have a spreadsheet that
sometimes we put hard coded number in a cell and other times there is a
calculation to get a number. I want to make sure hrad coded numbers get
highlighted while formula cells preserve their orignial formatting.

Thank you in advance,

Regards,

Nikki