Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Color Format
Can I get Excel to tell me how many items in a column are
colored red? I would just count them, but the column has over 40,000 rows. |
#2
|
|||
|
|||
Not by using any built in functions, you need VBA see:
http://www.cpearson.com/excel/colors.htm -- Regards, Peo Sjoblom "Reggie" wrote in message ... Can I get Excel to tell me how many items in a column are colored red? I would just count them, but the column has over 40,000 rows. |
#3
|
|||
|
|||
See http://www.xldynamic.com/source/xld.ColourCounter.html
-- HTH RP (remove nothere from the email address if mailing direct) "Reggie" wrote in message ... Can I get Excel to tell me how many items in a column are colored red? I would just count them, but the column has over 40,000 rows. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|