If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
countif
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
|
|||
|
|||
See
http://cpearson.com/excel/colors.htm In article , "mike" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combining IF and COUNTIF based on two columns | maxtrixx | General Discussion | 5 | March 31st, 2005 06:21 PM |
COUNTIF almost does it but... | Stevej | Worksheet Functions | 2 | August 27th, 2004 11:58 PM |
Countif | Doug | Worksheet Functions | 7 | July 1st, 2004 04:35 AM |
Countif trouble | Andy B | Worksheet Functions | 2 | March 15th, 2004 04:57 PM |
Pb on Countif | Paul | Worksheet Functions | 0 | December 23rd, 2003 11:35 AM |