View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
force530 force530 is offline
external usenet poster
 
Posts: 8
Default How do I count a red number

Just a red 0 for example. Not conditional. I have a list of black and red 0's
in column A2:A100 and I want to count the number of red ones.

"John C" 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.
--
John C


"force530" wrote:

How do i count a range of cells that have a red character; like a red 0?