For numbers being minus or plus ones, I use custom formatting the cells -
[black]0.0;[red]-0.0
Wonder if this could be used with other values or text.
DrB
"terry" wrote in message
...
I'm trying to write a formula that will change cells to a different color
according to a date range given.
|