View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Format based on cell contents being a formula or not

How do I format a cell with red highlights if it contains a value and leave
it alone if it containes a formula? I useed =isformula(F6)=FALSE with Excel
2007 conditional formatting but now can't get it to work.