Modifiying List template in PrintableCal

Need help with VueMinder Pro or Ultimate? Ask your questions here.
dglp
Posts: 14
Joined: Thu Jan 28, 2010 1:44 am

Modifiying List template in PrintableCal

Post by dglp » Sat Feb 27, 2016 2:58 pm

I'm now the happy owner of a PrintableCal license, and am wanting to modify the List template to make things a bit simpler for my record-keeping.

At the moment I'm puzzled about the way cells are formatted on the fly.
If I set a cell format (fill, border, font etc) on the top line of data (row 3 as it happens) when making a template, the subsequent rows stay with the default formatting when I create a new list using that template.

So what controls the formatting of generated rows?

User avatar
VueSoft
Dan Chartrand
Posts: 3874
Joined: Sat Aug 23, 2008 12:39 am
Location: St. Louis, Missouri, USA
Contact:

Re: Modifiying List template in PrintableCal

Post by VueSoft » Sat Feb 27, 2016 10:12 pm

Hi dglp, the List template doesn't apply the formatting of row 3 to the following rows. You can customize the template to format the rows as you'd like. Select a range of rows (such as 3 to 1000) and then set the desired format. When the list generates, you'll see all the rows within the customized range use the format you specified.

I hope that helps. Please let me know if you have any other questions.
Dan Chartrand, Founder
VueSoft LLC | St. Louis, Missouri, USA

dglp
Posts: 14
Joined: Thu Jan 28, 2010 1:44 am

Re: Modifiying List template in PrintableCal

Post by dglp » Sun Feb 28, 2016 6:09 am

Thanks Dan,

That leads to partial success.
I've set rows in alternate colors, which works.
I've also set a lower border on alternate rows, but that has been overwritten in the generated calendar.

User avatar
VueSoft
Dan Chartrand
Posts: 3874
Joined: Sat Aug 23, 2008 12:39 am
Location: St. Louis, Missouri, USA
Contact:

Re: Modifiying List template in PrintableCal

Post by VueSoft » Sun Feb 28, 2016 10:08 pm

Hi dglp, the border color comes from a conditional format. You could edit the conditional format to use the border color you'd like, or delete the conditional formatting rule. I assume you're familiar with conditional formatting in Excel. If not, the page linked below provides more detail:
https://support.office.com/en-us/articl ... 951FF89D7F

Many of the other PrintableCal templates also use conditional formatting rules, not just the List template.

I hope that helps. Please let me know if you have any other questions.
Dan Chartrand, Founder
VueSoft LLC | St. Louis, Missouri, USA

dglp
Posts: 14
Joined: Thu Jan 28, 2010 1:44 am

Re: Modifiying List template in PrintableCal

Post by dglp » Mon Feb 29, 2016 5:40 am

OK. I half suspected as much. Thanks for the clarification.

Post Reply