Forum Discussion
Printing blank pages with conditional formatting
NV_Social_Worker I would suggest a redesign of the form. Avoid conditional formatting, avoid merged cells. In stead, use a structured table to capture input. Center texts across selected cells (this is in the alignment options the Home ribbon). This will create the same visual effect as merged cells without the problems that often arise with merging. I've also used some radio buttons to select the type of therapy given. More intuitive and you can only select one at the time.
If needed, you can add Data Validation to the cells/ranges that require input. Like the date column shall only accept dates between a start date and an end date, minutes must be a number between 1 and 600 (as an example) and the service columns may only contain "x".
The table expands automatically once a new entry is typed directly beneath it.
Set the page lay-out to print one page wide by <blank> tall. This will automatically print the used range.
Since your users seem to be therapists of some kind, they must be capable of learning a few simple rules for filling in a form. They don't have to become Excel wizards. See if this works for you.
- NV_Social_WorkerNov 10, 2020Copper Contributor
Riny_van_Eekelen Thank you, so much! I will try this to see if it works.