Conditional formatting lost outside print area

[SeanRWisner]

I have a three sheet workbook that I created

The first sheet is virtually blank it allows the user to cut and paste dispatch info, and customer info from Lotus Notes Dispatching which is then referenced to auto populate appropriate cells in Service Report(third sheet)

The second sheet uses significant conditional formatting to aid the user in entering data in a very easy to use straight down vertical manner.

There are 74 rows of data entered followed by several comment areas which all also auto populate to the third sheet(service report).

Issues I am having, I only want the third sheet (service report) to print, but I want all conditional formatting to be visible to the user
At one point I put all three portions on a single sheet and set print range to exclude that which I don't want printed but then all formatting is masked and cells are just gray.

I would prefer to have the three sheets remain separate and to only print the third sheet, but need conditional formatting to remain functional and visible.

 

[Andrew Poulsom]

Welcome to MrExcel.

What do you mean by "I only want the third sheet (service report) to print, but I want all conditional formatting to be visible to the user" exactly? Visible where?

 

[SeanRWisner]

I mean that the user (service tech) who is entering the data should see all of the conditional formatting on the second sheet. This formatting indicates data that has not yet been entered and data that falls outside of certain parameters which may indicate trouble shooting required on machines.

However when printing the service report for the customer I only want the third sheet to print, it prints as a single landscape page.

 

[Andrew Poulsom]

Sorry, I still don't understand. What has printing got to do with the visibility of conditional formatting?

 

[SeanRWisner]

When I set the data entry area outside the print area it all goes gray(no conditional formatting).

The only way I have been able to restore the conditional formatting is to reset it into the print area, this was with all three on the same sheet, which I did because I could not find any method for setting sheet 3 to print without printing sheets 1 & 2.
I don't want them all on one sheet any way, because the columns and rows are so dissimilar, because sheet 3(service report) is a long used format, I have added the other two pages to make integrate the newly adopted dispatching format and make entering the many data values much easier for the technician, so they can just enter value and hit tab or enter, rather than having to find and click in each parameters cell.

 

[Andrew Poulsom]

Are you using Page Break Preview instead of Normal View?

 

[SeanRWisner]

Yes, I am using page break view....
Sometimes things can be so simple they are complicated.