View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
James Silverton[_2_] James Silverton[_2_] is offline
external usenet poster
 
Posts: 115
Default SUM only black numbers and leave out the RED ones

Jon wrote on Thu, 28 Feb 2008 19:48:00 -0500:


JP "James Silverton" wrote in
JP 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.

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

Basically, as I indicated, I want large changes to stand out so
I have things arranged so that if a change is more than 1.5 ESDs
it is displayed in red. I'd call that "conditional formatting".


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not