| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting cell that are fomated a particular fill colour
Is there a way a "Novice" could count a range of cells and return how many
are filled with red? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting cell that are fomated a particular fill colour
"Andrew@rushington" wrote in
message ... Is there a way a "Novice" could count a range of cells and return how many are filled with red? This requires a macro. It is well explained he http://www.cpearson.com/excel/colors.htm |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting cell that are fomated a particular fill colour
ok, thay seems to work although i have no experience with VBA i managed it,
but how do i know what colour is what number? thanks "Stephen" wrote: "Andrew@rushington" wrote in message ... Is there a way a "Novice" could count a range of cells and return how many are filled with red? This requires a macro. It is well explained he http://www.cpearson.com/excel/colors.htm |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting cell that are fomated a particular fill colour
Did you read the section " Returning the ColorIndex of a cell" in the web
page I gave you? "Andrew@rushington" wrote in message ... ok, thay seems to work although i have no experience with VBA i managed it, but how do i know what colour is what number? thanks "Stephen" wrote: "Andrew@rushington" wrote in message ... Is there a way a "Novice" could count a range of cells and return how many are filled with red? This requires a macro. It is well explained he http://www.cpearson.com/excel/colors.htm |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting cell that are fomated a particular fill colour
yeah i have now, thank for your help.
"Stephen" wrote: Did you read the section " Returning the ColorIndex of a cell" in the web page I gave you? "Andrew@rushington" wrote in message ... ok, thay seems to work although i have no experience with VBA i managed it, but how do i know what colour is what number? thanks "Stephen" wrote: "Andrew@rushington" wrote in message ... Is there a way a "Novice" could count a range of cells and return how many are filled with red? This requires a macro. It is well explained he http://www.cpearson.com/excel/colors.htm |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting cell that are fomated a particular fill colour
No VBA or color number required:
Edit Find Find what: clear it if filled Options Format.. Choose Format from Cell Click any red cell Find All The number of cells will appear in the lower left corner of the Find window. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting cell that are fomated a particular fill colour
Versions earlier than 2003 do not have this function.
Also, if the cells are colored due to Conditional Formatting it won't work. Gord Dibben MS Excel MVP On Fri, 7 Dec 2007 10:48:41 -0800 (PST), Herbert Seidenberg wrote: No VBA or color number required: Edit Find Find what: clear it if filled Options Format.. Choose Format from Cell Click any red cell Find All The number of cells will appear in the lower left corner of the Find window. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting cell that are fomated a particular fill colour
My Excel 2002 SP3 has this function
|
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
counting cell that are fomated a particular fill colour
Apologies Herbert
I have not used 2002 for a couple of years so I guess I forgot 2002 had that function. Gord On Fri, 7 Dec 2007 14:14:28 -0800 (PST), Herbert Seidenberg wrote: My Excel 2002 SP3 has this function |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep the cell colour fill when pasting in text? | Excel Discussion (Misc queries) | |||
| weird no more cell fill and text colour | Excel Discussion (Misc queries) | |||
| I cannot add fill colour to any cell, or use coloured text | Excel Worksheet Functions | |||
| i want to Fill Color in a cell but dont want the colour to print? | Excel Discussion (Misc queries) | |||
| Changing Cell Fill Colour | Excel Discussion (Misc queries) | |||
![Andrew@rushington[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
