View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hkbarnett hkbarnett is offline
external usenet poster
 
Posts: 2
Default Conditional format to highlight only cells with formula, not const

I am trying to set up a spreadsheet that will change the cell color if the
formula in the cell has been replaced with a specific value.
Is there any way to conditional format all cells that contain a formula, but
not a constant?

Herb