how to give uniquie number to cells containing same color

[genetist]

Hi to all,
I have excel sheet which contains cells with different color and i want to give 1 number to all cella containing blue color and 2 for red like this. How can i approach to solve this problem? is if conditions will work for it? or i have to go for macros? please help me
Thanks in advance,
Regards,
Genetist

 

[patel45]

please upload a sample file (with current data and desired result) on a sharing site, then paste the link here

 

[Comfy]

Excel 2010
	A	B	C
1		3
2		44
3		43
4
5
6			43
7			3
Sheet1

Cell Formulas
Range	Formula
B1	=Cell_Colour(A1)
B2	=Cell_Colour(A2)
B3	=Cell_Colour(A3)
C6	=Cell_Colour(C6)
C7	=Cell_Colour(C7)

Function Cell_Colour(ByVal Target As Range)
Cell_Colour = Target.Cells.Interior.ColorIndex
End Function