Sorry forgot to mention I cannot use macros due to company security settings.

"Atishoo" wrote:

Use VBA (alt F11)

if --------
then
ActiveSheet.PageSetup.PrintArea = -------
end if

"PhilosophersSage" wrote:

Is there a way to set a conditional print area? I have a spread sheet that
has several sections and want to print based on a formula. If anyone can help
thanks in advance!