Hi bob..

Normally I refuse to do "calculation with colors".

I can easily convince my clients it's NOT a good idea.
and it should work the other way. Much safer to store a value and
display a color. You just need a simple UI to enter those values


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Bob Phillips wrote :

It's all about design Jurgen (which is nothing new to you I know),
but my experience is that users just want to be in and out. Needing
them to do say a recalc is alien to them, so they probably won't. IMO
we either sort it for them or we don't use it. I gave such a method
in my first post to the OP.

I often give suggestions on say counting by colour and recently I was
(gently) chided by Biff (at least I thin it was he), suggesting that
these are not good solutions. I some ways you have to agree.

Regards

Bob

"keepITcool" wrote in message
ft.com...
aha... I see and I concur :)

--
keepITcool
www.XLsupport.com | keepITcool chello nl | amsterdam


Bob Phillips wrote :

My point, maybe not well made, is that saying press recalc is not
really good enough on a spreadsheet, we should look for some other
automated method, or don't use colour in formulae.