| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to count cells in a range based on fill color?
I have a workbook that uses the fill color as a dimensionof the data (
currecy of training). I want to automate statistics without counting cells and entering the number. I would like to do some thing like countif the fill is red. IS there a way to set the fill value to a variable to count with? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to count cells in a range based on fill color?
Hi
Have a look here for some help: http://www.cpearson.com/excel/colors.htm Andy. "eehinmd" wrote in message ... I have a workbook that uses the fill color as a dimensionof the data ( currecy of training). I want to automate statistics without counting cells and entering the number. I would like to do some thing like countif the fill is red. IS there a way to set the fill value to a variable to count with? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a way to count cells in a range based on fill color?
Thanks for the tips. This seems to be what I was looking for.
"AndyB" wrote: Hi Have a look here for some help: http://www.cpearson.com/excel/colors.htm Andy. "eehinmd" wrote in message ... I have a workbook that uses the fill color as a dimensionof the data ( currecy of training). I want to automate statistics without counting cells and entering the number. I would like to do some thing like countif the fill is red. IS there a way to set the fill value to a variable to count with? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto color fill cells | New Users to Excel | |||
| How do I sort or count cells by fill color? | Excel Discussion (Misc queries) | |||
| color fill cells based on IF function or formula | Excel Worksheet Functions | |||
| automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Linear Mode
