| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - new data
Excel 2007
I have multiple conditional formatting schemes set up for worksheet. When I paste new data into the sheet, how do I apply the formatting? It disappears when I paste and the only way I can apply it is to re-select the ranges. What am I missing? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting - new data
Paste special as values
-- Regards, Peo Sjoblom "jmegdan1" wrote in message ... Excel 2007 I have multiple conditional formatting schemes set up for worksheet. When I paste new data into the sheet, how do I apply the formatting? It disappears when I paste and the only way I can apply it is to re-select the ranges. What am I missing? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting - new data
EditPasteSpecialValues instead of paste
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jmegdan1" wrote in message ... Excel 2007 I have multiple conditional formatting schemes set up for worksheet. When I paste new data into the sheet, how do I apply the formatting? It disappears when I paste and the only way I can apply it is to re-select the ranges. What am I missing? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting - new data
Ok. Found the problem. Deleted previous rows and added new data. CF
formula reflects the gap of the deleted rows. Is there a way to lock the condition ranges? I suppose I could just highlight cells and delete but there is a lot of data. "jmegdan1" wrote: Excel 2007 I have multiple conditional formatting schemes set up for worksheet. When I paste new data into the sheet, how do I apply the formatting? It disappears when I paste and the only way I can apply it is to re-select the ranges. What am I missing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting-different data to one color | Excel Discussion (Misc queries) | |||
| Data Tables and Conditional Formatting | Charts and Charting in Excel | |||
| Data Validation & Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting in a data table | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Hybrid Mode
