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?