That's it! Thank you for the code!



"Pelusa" wrote:

I'm trying to set up an automatic work schedule.
I have 10 names (cells are color shaded by a unique color)
How do I carry that individual's cell color in to a new cell with some sort
of formula? or what is the formula for cell color shades?