| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting disappears when cell contents deleted
Hi,
Am Sat, 21 Jul 2012 17:04:30 +0000 schrieb wardw: I'm having a problem with a conditional format formula disappearing from a cell when I paste another cell's contents into it and then delete the content. if you paste another cells contents you paste all, also the cells format. Therefore the CF disappears. Copy the cell and then Paste Special = Paste values. And the formula for CF you can shorten: =AND(K192*L1920,M192=0) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting using part of the cells contents | Excel Discussion (Misc queries) | |||
| conditional formatting based on cell contents | Excel Programming | |||
| Conditional Formatting - For 1 cell based on contents of any cell | Excel Discussion (Misc queries) | |||
| Conditional Formatting/Contents | Excel Worksheet Functions | |||
| conditional formatting "if part of cell contents contains string" | Excel Worksheet Functions | |||
Threaded Mode
