|
|||||||
![]() |
|
|
LinkBack | Thread Tools | Search this Thread |
Rating:
|
Display Modes |
|
|
#1 |
|
Member (9 bit)
Join Date: Aug 2003
Posts: 313
|
Excel, Want to Count Colors
Okay, so in excel I am filling data with various colors so that I can visually compare using a color-coded ranking system. However, I don't know how to get the count function to count colors. Are there numbers associated with each hue that I can use as criteria?
|
|
|
|
|
|
#2 |
|
Computing Professor
Staff
Premium Member
Join Date: Jun 2001
Posts: 11,718
|
Check this out : http://www.mrexcel.com/td0106.html
__________________
Asus M4A77D, 64 X2 6000+, 4 GB Corsair DDR2 800 ram, Radeon 5770. |
|
|
|
|
|
#3 |
|
Member (9 bit)
Join Date: Aug 2003
Posts: 313
|
Unfortunately I don't know anything about Visual Basic and that information didn't seem to help! Arghh, but thanks.
|
|
|
|
|
|
#4 |
|
Computing Professor
Staff
Premium Member
Join Date: Jun 2001
Posts: 11,718
|
This may help : http://www.mvps.org/dmcritchie/excel/colors.htm
and this for Excel 2007 : http://msdn2.microsoft.com/en-us/library/cc296089.aspx but a copy of "Excel For Dummies" will help more. You need to know and understand a few basic commands in vb, sort of like saying please and thank you in another language, but that's it. That's how you create custom solutions. |
|
|
|
|
|
#5 |
|
Member (9 bit)
Join Date: Aug 2003
Posts: 313
|
Thank y'all for the help but I found it here: http://www.cpearson.com/excel/MainPage.aspx
That website is incredible! It has hundreds if not thousands of functions and other forms of information about Excel and the Microsoft Suite programs. |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problem With Excel Launch | Tom Jensen | Windows Legacy Support (XP and earlier) | 2 | 01-22-2008 10:51 AM |
| 256 colors missing !!! | shoesup | Windows Legacy Support (XP and earlier) | 4 | 03-30-2003 09:27 AM |
| Excel prob: Compile error in hidden module | calamospiza | Software Discussion & Support | 2 | 09-24-2002 04:12 AM |
| How to convert Lotus 123 to Excel? | robbsafc | Software Discussion & Support | 3 | 03-09-2002 04:31 PM |
| Dr. Suess goes to Fla. | troysvihl | Political Auditorium | 1 | 11-28-2000 12:51 PM |