to get cell color value

[sumesh56]

In my worksheet I have some cells colored using conditional formatting. I want to pull out the row data based on the color of the cell. what i have done is named the range as cellcolor.. then when i typed =cellcolor, instead of getting the colorcode i get zero... how can i pull out the row data based on the color of the cell into colum J using the if function or anything like .pl see the attached