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

"peter" wrote ...

cells to
turn one color when the value is positive and another
color when the value is
negative.


highlight the cell and click format|conditional formating


Also, can use the older style custom number formats e.g.

[Blue]General;[Red]-General;[White]General

Anyone know where that KB article with details on these formats or has
a copy somewhere?

Jamie.

--