How to copy formatting in validation cells?

=?Utf-8?B?aWFta3Jpc2M=?=

Guest

Posts: n/a

21st Jun 2007

In MS Excel I have a list of cells which I use for Validation in another
column. I want to be able to format certain cells in this list and when the
cell is validated in the other column have the format stay the same as the
list. How do I do this?

« Referencing within a GetPivotData function | Compare lists in Multiple workbooks »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Cells - Data Validation/Conditional Formatting	ray963	Microsoft Excel Misc	1	19th Nov 2008 02:19 AM
copy conditional formatting across all cells in column	Rosanne	Microsoft Excel Programming	1	16th Oct 2008 06:53 PM
Protect Data validation cells from copy paste	Guneet Ahuja	Microsoft Excel Misc	3	21st May 2008 04:07 PM
How To Copy Conditional Formatting to Several (1,000) Cells	=?Utf-8?B?Q2FtZXJvbiBEb2Nrc3RhZGVy?=	Microsoft Excel Discussion	2	30th Apr 2006 10:26 PM
Conditional formatting.. how do I copy cells?	=?Utf-8?B?cmF2ZW5fZ3V5?=	Microsoft Excel Misc	2	21st Jun 2005 03:17 PM