Thread: Find Cells that do not have Formulas in them.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
  
Posts: 695
Default Find Cells that do not have Formulas in them.
try F5


"Tony" skrev:

I have a spreadsheet with two tabs Sheet1 and Sheet2. Sheet 1 has data in the
cells. Sheet2 has formulas in the cells that reference Sheet1. In Sheet2
there are 1,000 rows and 40 columns. The problem is I have cells that are
missing formulas in them. How do I create a function that will highlight the
cells that are missing formulas. I tried playing with conditional format and
failed.

Thanks in advance.
Reply With QuoteReply With Quote