Go Back   PCMech Forums > Help & Discussion > Software Discussion & Support

Need Some Help? Type Your Keywords Here:

Reply
 
LinkBack Thread Tools Search this Thread Rating: Thread Rating: 1 votes, 1.00 average. Display Modes
Old 03-08-2008, 10:44 AM   #1
LoC
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?
LoC is offline   Reply With Quote
Old 03-08-2008, 12:04 PM   #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.
pam123 is offline   Reply With Quote
Old 03-08-2008, 04:39 PM   #3
LoC
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.
LoC is offline   Reply With Quote
Old 03-08-2008, 06:15 PM   #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.
pam123 is offline   Reply With Quote
Old 03-08-2008, 07:25 PM   #5
LoC
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.
LoC is offline   Reply With Quote
Reply

Bookmarks

Still Need Help? Type Your Keywords Here:


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT -5. The time now is 04:42 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.0 PL2