This uses VBa.
Add the developer toolbar to the ribbon. In the Controls panel, click Insert and click on the button
Draw a button on your Excel work sheet. Click OK.
In the new Window, type the following so only this code is on the page (nothing else)
Dim i As Integer
i = 1
For Each c In range("A1:A10") 'UPDATE THIS FOR THE CORRECT RANGE
If c.Font.ColorIndex = 3 Then
Range("M" & i).Formula = "=HYPERLINK(" & c.Address & ", " & c.Address & ")" 'CHOSE EMPTY COLUMN
i = i + 1
In this example, I've chosen a free column (M) in this case. If M isn't free, then do change the M to a column which is free. You will also need to state the correct index range.
So, every time it finds a cell with the red font (with index of 3) it will write the value to the M column. So with your new list, you can navigate to the cell in question easily.
Big thank you to @mehow who suggested making the results clickable.