Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you want to remove conditional formatting, select CF and then Delete
button. You can then delete any or all of the conditions. Is this what you want to do? "leo" wrote: 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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
NO, not exactly.
The conditional formatting result is what I want to keep. Deleting the CF will remove the coloring too. (reason I want the cf removed is the time it takes and slows down the workbook activity.) I have 1200 lines and 45 rows that for each cell check approx. 100.000 records to base the cf on. Once that is done I want the color to remain as CF defined, But need to do further steps in processing the data. "Toppers" wrote: If you want to remove conditional formatting, select CF and then Delete button. You can then delete any or all of the conditions. Is this what you want to do? "leo" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |