"Andibevan" wrote in message
...
I would recommend that you look at conditional formatting
(FormatConditional Formatting). This allows you to choose 3 conditions
and
associate different formatting for each condition. Have a quick read of
the
help file as well.

I have always used conditional formatting - it never occured to me to use
your method - very inventive.

Actually, this technique I stumbled upon thanks to your help has been
working extremely well in a couple of other applications since then.

One other advantage has occurred to me. Using cell conditions also means
that the user can't easily or inadvertently corrupt anything. So, then, we
have the fact that this way the user is less likely to corrupt the
spreadsheet as well as the original huge advantage of having complete result
values available for other formulas in other cells. This was something not
always true when we tried programmatically changing how the cell results
were displayed rather than just with colour control of font and background.
End results are the same anyway, just one is a heck of a lot easier to do
than the other! <g

To recap, cell condition was used for when cell values are equal to 0, as
one case. Here, the cells were formatted with font colour and cell
background a certain way, usu. same colour so that "0" values don't show up
to the user. Then the 2 other conditions also dealt with with different
font and cell backgrounds for cell values greater than 0 and cell values
less than 0.

Thanks. :oD