Thread: Counting based on format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Counting based on format
See

http://cpearson.com/excel/colors.htm

In article ,
"TJ" wrote:

Hi

Is there a worksheet function, or combination of functions, that I can use
to count how may cells in a row have a background of red? E.g
=Countif(A2:A10, "Background = Red").

Thanks
TJ
Reply With QuoteReply With Quote