Can color codes be used in formulas to seperate data?

's Computer Specifications

I have a pay sheet that has a cell that we use for leave can I use colors
i.e. red=sick leave blue=annual leave green=leave without pay and hve it
transfer that information to the appropriate column in another document in
excel?

's Computer Specifications

Hi Phazer,

Take a look at this site.
http://xldynamic.com/source/xld.ColourCounter.html

HTH
Martin

"Phazer" <(E-Mail Removed)> wrote in message
news:8B2AADB4-C744-46AE-B52A-(E-Mail Removed)...
>I have a pay sheet that has a cell that we use for leave can I use colors
> i.e. red=sick leave blue=annual leave green=leave without pay and hve it
> transfer that information to the appropriate column in another document in
> excel?

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: Color Codes: Different color with same color Index	Ryan H	Microsoft Excel Programming	0	5th Feb 2010 04:46 PM
How do I seperate data from a pivot into seperate worksheets?	=?Utf-8?B?U2hhbm5vbg==?=	Microsoft Excel Misc	5	25th Aug 2005 06:07 AM
How do I get two seperate accounts to use two seperate data files?	=?Utf-8?B?U291cnRvbmU=?=	Microsoft Outlook Installation	1	24th Feb 2005 02:50 AM
Seperate Notes/Memo field into seperate data fields	Joe Williams	Microsoft Access Queries	5	4th Jul 2004 09:55 PM
insert data from seperate worksheet into seperate colums depending on list selection	RPIJG	Microsoft Excel Worksheet Functions	2	10th May 2004 04:19 PM