Find Cells that do not have Formulas in them.

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
Cell highlighting question 4
Populate worksheet with data that meets date range criteria 3
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Help with Conditional Format Formula 6
how do I create a nonadjacent series for autofill to go by? 3
Formulas That Reference ADJACENT Sheet 4
formula output 1

Top