[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 791
  • Last Modified:

Excel - Permanent Conditional Formatting

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
tahirih
Asked:
tahirih
  • 4
2 Solutions
 
tahirihAuthor Commented:
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
 
jppintoCommented:
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
 
tahirihAuthor Commented:
Not able to locate this file.

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

Thank you.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
KPAYNE123Commented:

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
 
tahirihAuthor Commented:
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
 
tahirihAuthor Commented:
Thank you.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now