Dave, That's exactly how I'm doing it now. I'm just wondering if each cell could call a sub that would do the formatting on the fly and not hard code it with each sheet. If there would be any advantage if it could be done.
On Jul 1, 10:29 pm, Dave Bonallack <davebonall...@hotmail.com> wrote: > Hi Doug, > > I think I would keep a sheet in the workbook called 'Template' which contains > all the formatting you want. Then each day, make a copy of that sheet, and > rename the copy as needed. Don't ever put data into your Template sheet. Just > use it to create new sheets. > > Regards - Dave. > > > > > > > Date: Wed, 1 Jul 2009 08:55:34 -0700 > > Subject: $$Excel-Macros$$ A question about conditional formatting > > From: dsrmccl...@gmail.com > > To: excel-macros@googlegroups.com > > > Just a quick question. > > > I'm writing a workbook in which a new worksheet will be added every > > day. Each worksheet contains a number of cells with the same > > conditional formatting applied. Is there any advantage to applying the > > formatting through VBA code as opposed to applying it through the > > Format menu? I'm thinking about how this workbook will grow in size as > > new sheets are added. > > > Thank you. > > _________________________________________________________________ > Looking for a place to rent, share or buy this winter? Find your next place > with > Ninemsn propertyhttp://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Edomain%2Eco...- > Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
