Prevent blank pages (with formulas) from printing

[NV Social Worker]

I have a workbook with formulas that result in blank cells, unless data is placed in other cells (A16:Y300). I only want the pages with data in them to print, but it is trying to print all of the blank pages that have formulas in them (I have rows 1:15 to print for each page). I am not familiar with macros or VBA, and am only moderately familiar with formulas. I know I can put in a filter to not print the blank pages, but I have people who will be using the workbook that can barely even input the data, and would not know how to use the filter. I would like for them to just click print and only the pages with data to print (currently, it is printing 10 pages). I looked through the message board and found this, which I have tried to no avail:

To not print formulas in blank cells:
Go to Formulas Tab
Click on Define Name
In Name box, type name of worksheet and Print_Area
In Scope box, click on the workbook
In the formula box (Refers to type in …
=OFFSET(Service Log!$A$1:$Y$1,0,0,LOOKUP(2,1/(Service Log!$A$2:$A$300<>""),ROW(Service Log!$A$2:$A$300)))

If anyone can assist me with this issue, I would be most grateful.

Thank you,

NVSW

 

[NV Social Worker]

I just realized, my cells do not contain formulas, but they do contain conditional formatting. I cannot find a way around this not printing 10 pages. Again, any assistance would be tremendously appreciated!