Thread: How do I count a red number
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default How do I count a red number

You need VBA code to do that. I have lots of examples, including
summing by color, at http://www.cpearson.com/excel/colors.aspx

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Tue, 14 Oct 2008 11:33:00 -0700, John C <johnc@stateofdenial
wrote:

What determines if something is red? Is it conditional formatting? You could
just do a count based on the conditional formatting if it is.
Reply With QuoteReply With Quote