Can color codes be used in formulas to seperate data?
 

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?

Can color codes be used in formulas to seperate data?
 

Hi Phazer,

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

HTH
Martin


"Phazer" wrote in message
...
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?