|re: Any ideas on how to code this in VBA...|
With the limited information you have provided, an "idea" is about all we can offer.
We don't know what you mean by any given row nor do we know where you want the cell pasted other than in another spreadsheet.
This "idea" will search Row 1 and copy the first cell whose Font color is Blue to Sheet2!A1.
Dim myCell As Range
For Each myCell In Rows(1).Cells
If myCell.Font.ColorIndex = 5 Then
Note: This code will copy the first cell whose font color has been set to blue. It will not copy a cell whose font color is blue because of Conditional Formatting.
If you'll provide us with some more details, we might have some other "ideas".