Counting Colors

g48dd · #1 03-13-2011, 06:54 AM

Using Excel 2003: This function will extract the index number of a cell that has color:

Code:

Function getcolor(cell)
getcolor = cell.Interior.ColorIndex
End Function

. It returns a number eg. A1 is yellow. In B1 I insert this function. and point the function to A1. It returns the number 6, becuse 6 is the index number for yellow. You can then sort that column and all of your rows will be sorted by color. However this does not work if the background color is the result of CONDITIONAL FORMATTING. I was wondering if there is someone who would know how to sort by color if the colors are the result of conditional formatting?

Thank you
Ken

macropod · #2 03-13-2011, 07:47 PM

Hi Ken,

Since you know the conditions that trigger the conditional formatting, simply test for those same conditions in your code.

g48dd · #3 03-13-2011, 09:28 PM

I understand what you are saying. I was sort of focused on returning the number I needed, look at the conditions that produce the result I need. This is not easy lol.

Ken

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatic counting in a looping powerpoint	RCU	PowerPoint	0	09-22-2010 12:28 PM
counting occurences of a value in a range but not including 0's nor blanks	virsojour	Excel	0	07-05-2010 01:34 AM
listing and counting words	gencoglux	Word	2	05-07-2010 05:10 PM
Counting Weeks	leroytrolley	Excel	1	08-18-2008 11:12 AM
Counting Legal Words	bulletrick	Word	0	12-30-2005 03:22 AM