Apply format/formula to all cells on spreadsheet

R

Rosemary

I'm doing a huge (17 page) spreadsheet that is linked to
13 subspreadsheets. I would like to apply an "isblank"
and "iserr" format to the entire spreadsheet. How can I
do this? Info is input onto the subs on a monthly basis,
but the cells that aren't used until later are showing
either "0"s [number format cells] or "#DIV/0!" [percentage-
-calculation] on the main spreadsheet. Can I do this,
and, if so, how? Thank you.
 

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

Word macro that can call cells out of Excel for a find and replace 0
Linked spreadsheet errors 2
Formating a row based on one cell's date 3
Missing default cell styles on some large existing spreadsheets 0
Conditional Formatting 1
Formula not being Friendly 3
Trying to calculate average call length 7
How do I hide a formula so it will not show on the spreadsheet? 1

Top