Hi Bart
you're welcome ... Chip has lots of great stuff on his website - my other
favourite is Debra Dalgleish's at
www.contextures.com/tiptech.html
more great sites are listed at
www.mvps.org - under "Excel" on the right
hand side of the screen (unless they've redesigned their site again!) and a
bit of a google search will turn up a number of lists of good excel sites.
Cheers
JulieD
"Bart Schouw" wrote in message
...
Julie, this is exactly what I need, great stuff, thanks for the hint!
Cheers
Bart
"JulieD" wrote:
Hi Bart
check out
http://www.cpearson.com/excel/colors.htm
for things you can do with cell colours
Cheers
julieD
"Bart Schouw" <Bart wrote in message
...
It would be great if you could get returned the colorcode of certain
cell,
based on this new calculcations are possible. For example some of my
turnover
is based on pre-sales, these cells have have a certain color. It would
be
great if i could count the number of cells with this color.