Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeze Conditional Formatting
My problem is this:
I have a bunch of conditional formatting for cells that I would like to Freeze (or burn) into the spreadsheet. That is, when you run the macro that performs this action, none of the formatting will appear changed to the user (because everything will look the same), but all the conditional formatting that was previously handled by Excel's conditional formats is now burned into the cells and will no longer change if you change the value of the cell. A simple case would be in the case of "banding", where i have alternating green and blank colored interiors for cells (created with conditional formatting). I would like the macro to operate on the current selection and set the formatting of the cells to what conditional formatting says they should be, and then delete the conditional formats. I have searched and searched and have not found anything on this topic. My initial attemps to deal with this problem have failed, and i see no quick way (100 lines or less of code) to comprehensively solve this problem. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeze Conditional Formatting
See Chip Pearson's page on this for some ideas:
http://www.cpearson.com/excel/CFColors.htm -- Regards, Tom Ogilvy "R Avery" wrote in message ... My problem is this: I have a bunch of conditional formatting for cells that I would like to Freeze (or burn) into the spreadsheet. That is, when you run the macro that performs this action, none of the formatting will appear changed to the user (because everything will look the same), but all the conditional formatting that was previously handled by Excel's conditional formats is now burned into the cells and will no longer change if you change the value of the cell. A simple case would be in the case of "banding", where i have alternating green and blank colored interiors for cells (created with conditional formatting). I would like the macro to operate on the current selection and set the formatting of the cells to what conditional formatting says they should be, and then delete the conditional formats. I have searched and searched and have not found anything on this topic. My initial attemps to deal with this problem have failed, and i see no quick way (100 lines or less of code) to comprehensively solve this problem. Any help would be appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeze Conditional Formatting
Excellent. This is definitely part of what i want. I assume i would have
to do the same thing for Borders formatting, font formatting, etc. Thank you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeze Conditional Formatting
Yes, I would think so.
-- Regards, Tom Ogilvy "R Avery" wrote in message ... Excellent. This is definitely part of what i want. I assume i would have to do the same thing for Borders formatting, font formatting, etc. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
freeze pane: freeze from two worksheets? | Excel Discussion (Misc queries) | |||
Is it possible to lock-in or freeze formatting? | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
Freeze Formatting | Excel Discussion (Misc queries) |