Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count format changes
I have a table with a list of personal names in a column, most of which are
entered in black text whilst a minority are entered in red text. I would like to know what steps I have to undertake to enter a formula that counts the number of red entries within the column. Any help would be much appreciated. |
#2
|
|||
|
|||
There is a solution at http://xldynamic.com/source/xld.SUMPRODUCT.html
-- HTH RP (remove nothere from the email address if mailing direct) "Dr. Juzzy" <Dr. wrote in message ... I have a table with a list of personal names in a column, most of which are entered in black text whilst a minority are entered in red text. I would like to know what steps I have to undertake to enter a formula that counts the number of red entries within the column. Any help would be much appreciated. |
#3
|
|||
|
|||
http://xldynamic.com/source/xld.ColourCounter.html
Thanks for that Bob! For future reference of other users, I've provided a direct link to instructions on processing coloured cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Telephone number format | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |