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 |
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 |
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 |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com