Solved

Excel - Permanent Conditional Formatting

Posted on 2011-03-16
6
751 Views
Last Modified: 2012-05-11
Hi,

Is there a way to save conditional formatting for all Excel 2007 workbooks that are  to be open, without having to redefine the conditions each time?

Thanks
0
Comment
Question by:tahirih
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 

Author Comment

by:tahirih
ID: 35151277
For example - in Column A

Any cell with:

IS = =yellow
GS = green
SBR = blue
DMG = orange
CLM = purple
CN = red
CR = brown

This will be consistent for values in Column A on many workbooks.
0
 
LVL 33

Accepted Solution

by:
jppinto earned 250 total points
ID: 35151279
You can do it by creating a Personal file (PERSONAL.XLS in Excel 2003 or in Excel 2007-2010 your PERSONAL.XLSB file).

What is it: This is a hidden workbook that opens when you start Excel.
The formatting that you put on this workbook is available in all workbooks you create after in Excel.

Where is it:
If it exists, you can find the file in the Excel startup folder.
Windows XP
C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART
In Vista or Windows 7 look here:
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTART

jppinto
0
 

Author Comment

by:tahirih
ID: 35151287
Not able to locate this file.

Is there a macro I can use to code the information I just offered?

Thank you.
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 5

Assisted Solution

by:KPAYNE123
KPAYNE123 earned 250 total points
ID: 35151327

Open a new workbook. Delete all but one of the worksheets by right clicking a tab and selecting Delete.

Change the page setup, if you choose. Go to the File menu in Excel 2003 or earlier and select Page Setup. In Excel 2007, go to the Page Setup group in the Page Layout tab. Adjust margins, change the page orientation and make any other changes you want to apply to default Excel workbooks.

If you want to change the default gridline color in Excel 2007, click the Office Button and select Excel Options. Click Advanced and find Display Options for this Worksheet. Select the Show Gridlines checkbox and choose a color from the Gridline Color drop down menu.

In Excel 2007, click the Office Button. Select Excel Options. Select a font and size under When Creating New Workbooks.

If you want a specific cell in the worksheet to be active when you open a new Excel workbook, click on the cell to select it. When you have made all of your desired changes, save to the file path of the xlstart folder on your computer. (Excel 2007 - C:\Program Files\Microsoft Office\Office 12\XLStart\) Enter Sheet as the file name. In the Save As Type drop down, select Template. Click Save.

Copy the worksheet to other tabs, if you want several tabs in your default workbook. Hold down the Ctrl key, click on the default sheet tab and drag it to the right to copy and create a new worksheet. Go back to the Save As menu and follow the same steps, but this time save it with the name book, again choosing Template in Save As Type. Restart Excel and check out your new default workbook and worksheets.
0
 

Author Comment

by:tahirih
ID: 35151391
KPayne - thank you so much for taking the time in responding. Can you please advise on how to create a macro that is color coded as mentioned above?

Thank you.
0
 

Author Closing Comment

by:tahirih
ID: 35202224
Thank you.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question