| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste conditional formats as formats
When having done an extensive conditional formatting I managed to get my
cells colored the way I want. However, the conditional formula is still active. Changing data will change the format. How can I fix the formatting result of the FIRST conditonal formatting so that changing data afterwards does not alter the foramt again. I have tried pasting special, but could not find the "undo" conditionals. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
| Excel - Need to paste special formats only bold | Excel Discussion (Misc queries) | |||
| Paste Number Formats | Excel Discussion (Misc queries) | |||
| Paste Special Formats Generated by Conditional Formatting | Excel Discussion (Misc queries) | |||
| how do I paste links and keep formats | Excel Discussion (Misc queries) | |||
Threaded Mode
