View Single Post
  #3   Report Post  
DrB
 
Posts: n/a
Default

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.