Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
i'd like to figure out how i can copy a group of cells that have a
conditional format (stoplight style ... color pattern highlighted for a certain condition) and paste special only the format, but not keep the conditional format rules. one time that it is necessary is if i have an analysis spreadsheet with all my rules and formulas and internals, but i produce an "output" spreadsheet that only shows values, widths and formats. the conditional format for a particular column depends on the values of a column which i don't even include in the output sheet, so the conditional formatting rules don't work as designed once transformed to the "output" sheet. hopefully this question makes sense! thanks for any tips, pointers, ideas. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
Problem with Conditional format deletion | Excel Discussion (Misc queries) | |||
deleting a conditional format | Excel Discussion (Misc queries) | |||
make a conditional format the default | Excel Discussion (Misc queries) | |||
Conditional format | Excel Discussion (Misc queries) |