Resolved Question: Using vba in excel to match cell by background color?

is it possible to use the match function in vba to match the background color?
like this?

Dim myvalue As Long
myvalue = Application.Match((Target.Interior.ColorIndex = 5), Range("N7:N16"), 0)
Range N17 = myvalue
End Sub
Ok, let me reiterate, i have a range of ten cells in a column. one of these cell has a background color the others are xlNone. i need to find the cell position and have that position populate another cell.

Is there a way i can do that?
Thanks cozmosis. let me try that. it seems like it will work fine. :)