About Us

wardw

Thank you, Spencer101 and Claus Busch; I'm now using Paste Special = Paste Values and the CF remains in the cell. And thanks for your shorter formula, Claus; it works fine.

Quote:

Originally Posted by Claus Busch

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
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting using part of the cells contents	Duey	Excel Discussion (Misc queries)	3	April 28th 10 10:04 AM
conditional formatting based on cell contents	marcia2026	Excel Programming	3	September 26th 08 07:22 PM
Conditional Formatting - For 1 cell based on contents of any cell	DJH	Excel Discussion (Misc queries)	3	September 12th 08 10:12 PM
Conditional Formatting/Contents	THINKINGWAY	Excel Worksheet Functions	3	December 28th 07 08:25 PM
conditional formatting "if part of cell contents contains string"	tom ossieur	Excel Worksheet Functions	1	March 13th 07 11:11 AM

Menu

About Us