Find Cells that do not have Formulas in them.
 

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.

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.

Find Cells that do not have Formulas in them.
 

THANK YOU, it worked.

"excelent" wrote:

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.

Find Cells that do not have Formulas in them.
 

F5 does it; it doesn't get any easier than that. If you feel a little more
ambitious, try this:
http://j-walk.com/ss/Excel/usertips/tip045.htm

I've used it with great success!!


Regards,
Ryan--

--
RyGuy


"Tony" wrote:

THANK YOU, it worked.

"excelent" wrote:

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.