Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting colors
have a 50 row listing of stores. each month(columns) the top seller has it
sales highlighted in red. want a countif is red in the row thanks |
#2
|
|||
|
|||
Hi there,
Take a look at Chip Pearson's work here ... http://www.cpearson.com/excel/colors.htm Note, this does not handle Conditional Formatting. If this is what is returning your color, you'll need to seek an alternate method(s). For an explanation on Conditional Formatting, Chip also has a page for that ... http://www.cpearson.com/excel/cformatting.htm To use CF colors as you would a standard colorindex of a cell, you can make use of a routine, something like the one found here ... http://vbaexpress.com/kb/getarticle.php?kb_id=190 HTH -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) "reno" wrote in message ... have a 50 row listing of stores. each month(columns) the top seller has it sales highlighted in red. want a countif is red in the row thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify the default graph colors | Charts and Charting in Excel | |||
Can I modify Excel 2003 color palette to accept Pantone colors? | Excel Worksheet Functions | |||
custom cell pattern colors | Excel Worksheet Functions | |||
How to add fill colors (cell shading) in EXCEL? | Excel Discussion (Misc queries) | |||
How do I get custom colors for filling cells in Excel? | New Users to Excel |