Print Ranges based on conditions
 

Is there a way you can set print ranges based on conditions - for example if
Cell A1<0 Print Range = ____; if A10 Print Range = ______

Also, can you hide rows/columns that do not have data from printing - for
example if you have a cell that specifies a contract is 5 years, but your
template is set up to print 10 years worth of data, can you only print
contract term? But set print range so that if the contract term is changed
to 6 years, the Year 6 column is now displayed.