worksheet function

[Natarajan Sivashanmugam]

I am having some set of values in a row. In that, some of
the values will be in a particular color. Now, I want to
copy the colored values alone to another row in their
respective rows. To copy those particular values, I am
doing it cell by cell. It is a time consuming process. So,
I need a function to do this. Thanks.

1 1
2 2
3
4 4
5

In the above values 1,2 and 4 is colored and I have to
copy those values alone to another row.

 

[Akshay Bakhai]

I think that you will need to do this with a macro. I do
not think that there exists a function to do what you want.

Akshay

 

[dvt]

I am having some set of values in a row. In that, some of

I think that you will need to do this with a macro. I do
not think that there exists a function to do what you want.

Yes, you probably need code. And here is a link that will help you create
that code...
http://www.cpearson.com/excel/colors.htm

Dave
dvt at psu dot edu