Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Can you please hel me to find the correct formulas | Excel Worksheet Functions | |||
where can I find help with excel formulas? | Excel Discussion (Misc queries) | |||
Formula help! Find and replace in formulas | Excel Discussion (Misc queries) | |||
I NEED TO FIND TWO FORMULAS | Excel Worksheet Functions |