View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave O. Dave O. is offline
external usenet poster
 
Posts: 5
Default Tracking progress and coloring numbers in a cell

I would like to track progress based on applications submitted per day. I
have a day cell and an application cell. I would like the next adjacent cell
to show tracking based on an average of 2.5 applications needed per day. If
the number is less than the 2.5 average I would like it to have a "-" in
front and appear in red. If the number is greater than the 2.5 average I
would like it to appear in green.
Thanks,
Dave