Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to use the countif function and I am wondering, is there a way to
count cells based on the background color of the cell. For instance if I have set the background as "grey". something like countif(backgrougn="grey")? Does anyone know if this is possible |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Mike,
See Chip Pearson's at: http://www.cpearson.com/excel/colors.htm --- Regards, Norman "mike" wrote in message ... I am trying to use the countif function and I am wondering, is there a way to count cells based on the background color of the cell. For instance if I have set the background as "grey". something like countif(backgrougn="grey")? Does anyone know if this is possible |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Need a little help w/ COUNTIF | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |