Find Cells that do not have Formulas in them.

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How Do I Avoid #REF! In Formulas? 4
add hyperlink using sheet names and cells(i,j) 3
Cell highlighting question 4
if statement, change cell only if true 4
Show formula result in another sheet 1
What formula do I use to show the last cell with text in a colum 3
Reference text in a cell inside a formula to specify a sheet name 4
view the formula 3

Back
Top