| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif based on fill color
Can anyone tell me how to do a countif based on cell fill color? I want to
count all cells I've filled in red. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif based on fill color
Not possible with built in functions unless you can use the criteria which
made you colour them in the first place, otherwise you will need code, either a macro or a UDF http://www.cpearson.com/excel/colors.htm -- Regards, Peo Sjoblom Portland, Oregon "edmcf@mot" wrote in message ... Can anyone tell me how to do a countif based on cell fill color? I want to count all cells I've filled in red. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
| How do I change fill color in excel based on data in the cell | Excel Worksheet Functions | |||
| counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
| Inserts and color fill | New Users to Excel | |||
| A different "Fill Color" problem | Excel Worksheet Functions | |||
Hybrid Mode
