View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Spreadsheet help

Highlight your group, Format - Cells - Number tab - Pick Number, then pick
from the negative numbers list.

" wrote:

If I have a group of equations with answers that are both positive and
negative is there a way to have the equations that provide a negative number
automatically show up in red lettering and positive show up in green letters.