Function that looks for a particular color in a row

[SamMaynard]

If I'm crazy just let me know.

I would like to have a function (worksheet function or vba doesn't matter) that looks into a range of cells for a particular cell color in that row and then returns the value in the cell.

You see, I'm using a matrix of cells for a chart and the chart uses different colors to signify whether an activity is complete or not. Anyway I just need to look into the row for a particular color, say red or green and then return that value.

ps. How do I find out what number code red or green is for the computer to know which color I'm looking for?

Please help.

 

[Greg Truby]

http://www.cpearson.com/excel/colors.htm

Scroll down to the function FindColor

As for the question in your postscript - see Chip's function CellColorIndex near the top of the page.

 

[TrippyTom]

I just wanted to point out these functions do not work with conditional formatting. I had a similar need for something I'm doing with calendars (paydays and holidays), but somehow the conditional formatting is not compatible with this guy's code.

I don't know what's wrong with it, or what's wrong with my code. I just wish I could make a work-around this frustrating issue.