Hi,

I dont know is it possible or not, but as per logics and with the help
of Macros I think we can do it.

A column with 2000 Rows.

A1 Akash (Red in Color)
A2 Akash (Blue in Color)
A3 Akash (Green in Color)
A4 Akash (Green in Color)
A5 Akash (Pink in Color)
A6 Akash (Blue in Color)
A7 Akash (Red in Color)

Now what i want that if the color of the text in A1 Cell is Red than
B1 should display 1

Now what i want that if the color of the text in A2 Cell is Blue than
B1 should display 2

Now what i want that if the color of the text in A3 Cell is green than
B1 should display 3

Now what i want that if the color of the text in A4 Cell is green than
B1 should display 3

Now what i want that if the color of the text in A5 Cell is Blue than
B1 should display 2

Now what i want that if the color of the text in A6 Cell is Red than
B1 should display 1.

I want the serian number as per the text color in the Column A.

Awaiting for the reply.

Thanks

Akash