Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Capture conditional format as cell format
Hi everybody,
I've got an Excel workbook that has conditional formatting (formula is linked to value in another cell). There are about 100 cells involved on 10 sheets. What I would like to be able to do is to save that formatting as the cell format i.e. just keep the colour to highlight the cell. Once the formatting is saved I would then like to be able to re-use the conditional formatting function (same criteria, different colour). The workbook is used for self evaluation and what the end user would like is to be able to see last year's marks and this year's - if it helps to know that. If anyone could help, that would be brilliant! Thank you Diddy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Capture conditional format as cell format
Conditional formatting only exists as a virtual format. There is no easy way
to capture it. This might be one of those cases where instead of using conditional formats you could use a macro to set your formats. Bare in mind that that is a fair bit of custom code to write. -- HTH... Jim Thomlinson "Diddy" wrote: Hi everybody, I've got an Excel workbook that has conditional formatting (formula is linked to value in another cell). There are about 100 cells involved on 10 sheets. What I would like to be able to do is to save that formatting as the cell format i.e. just keep the colour to highlight the cell. Once the formatting is saved I would then like to be able to re-use the conditional formatting function (same criteria, different colour). The workbook is used for self evaluation and what the end user would like is to be able to see last year's marks and this year's - if it helps to know that. If anyone could help, that would be brilliant! Thank you Diddy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Capture conditional format as cell format
Thanks Jim,
The cells with conditional formatting are directly above the cells whose value informs the conditional format. Could you give me a pointer as to how to go about coding, or should I repost in programming? I've only dabbled so not sure what I need to do. Thanks again :-) Diddy "Jim Thomlinson" wrote: Conditional formatting only exists as a virtual format. There is no easy way to capture it. This might be one of those cases where instead of using conditional formats you could use a macro to set your formats. Bare in mind that that is a fair bit of custom code to write. -- HTH... Jim Thomlinson "Diddy" wrote: Hi everybody, I've got an Excel workbook that has conditional formatting (formula is linked to value in another cell). There are about 100 cells involved on 10 sheets. What I would like to be able to do is to save that formatting as the cell format i.e. just keep the colour to highlight the cell. Once the formatting is saved I would then like to be able to re-use the conditional formatting function (same criteria, different colour). The workbook is used for self evaluation and what the end user would like is to be able to see last year's marks and this year's - if it helps to know that. If anyone could help, that would be brilliant! Thank you Diddy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy conditional format without using format painter | Excel Worksheet Functions | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |