Home |
Search |
Today's Posts |
#1
|
|||
|
|||
make a conditional format the default
I have a conditional format that highlights the protected ( locked) cells in a different colour. How can I save this format as the default format to be used automatically when I start a new worksheet regards fred from south africa -- Think of the trees - use both sides of the computer paper |
#2
|
|||
|
|||
Hi Fred,
See response to your post lat week: http://tinyurl.com/6l8pz --- Regards, Norman "Fred Evans" wrote in message ... I have a conditional format that highlights the protected ( locked) cells in a different colour. How can I save this format as the default format to be used automatically when I start a new worksheet regards fred from south africa -- Think of the trees - use both sides of the computer paper |
#3
|
|||
|
|||
Look in HELP for TEMPLATE on how to make a sheet.xlt and where to put it.
-- Don Guillett SalesAid Software "Fred Evans" wrote in message ... I have a conditional format that highlights the protected ( locked) cells in a different colour. How can I save this format as the default format to be used automatically when I start a new worksheet regards fred from south africa -- Think of the trees - use both sides of the computer paper |
#4
|
|||
|
|||
thank you -- i will keep a note of this
regards fred "Don Guillett" wrote in message ... Look in HELP for TEMPLATE on how to make a sheet.xlt and where to put it. -- Don Guillett SalesAid Software "Fred Evans" wrote in message ... I have a conditional format that highlights the protected ( locked) cells in a different colour. How can I save this format as the default format to be used automatically when I start a new worksheet regards fred from south africa -- Think of the trees - use both sides of the computer paper |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
format one data series, with error bars, and use it as default | Charts and Charting in Excel | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
How can I change the default 'comma' format. Eg paranthesis inste. | Excel Discussion (Misc queries) | |||
Conditional format | Excel Discussion (Misc queries) |