View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default SUM only black numbers and leave out the RED ones


"James Silverton" wrote in message
...
Jon wrote on Thu, 28 Feb 2008 17:16:22 -0500:

JP -Usually these criteria are manually applied.

Is that so! Not meant sarcastically but I only use a numerical criterion
concerning standard deviations to high-light in red. There is also the
Number format using a different color for negative numbers.


I was thinking of so many of the cases of actual human usage I've observed.
Conditional Formatting? What's that?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______