View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default how do I use COUNTIF stmnt if I want to find cells that are red

You can't directly look for the color of a cell in a Countif.

You could, however, use in the Countif the same condition that turns the
cell red.

Regards,
Fred.

"kisboros" wrote in message
...
Can COUNTIF work if I want to count cells that are highlighted, let's say,
red?
Thank you.