Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Cells with Formulas
I inherited a spreadsheet with 52 tabs of tables, each table 21 columns by 8
rows. MOST cells have a VLOOKUP formula in them, the rest, someone has plugged in a number. Is there a way to conditionally format the sheet to show which ones do NOT have a formula? I know Ctrl + ` will SHOW formulas, but I'd like to highlight them. (So I guess my Subject line is backwards) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Cells that do not have Formulas in them. | Excel Worksheet Functions | |||
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) | |||
I NEED TO FIND TWO FORMULAS | Excel Worksheet Functions |