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
|