Search coloured cell in worksheet and list the cell location

[kala_vita]

Hi all

I have a worksheet size roughly 100 * 400 cell.
there is roughly 100 cells filled with RED color and with different value.

When i used FIND ALL format - RED, I can locate the cell location and the cell value.
And I wish to copy these 2 info onto a new sheet so that on the new sheet, I can create a hyperlink and easily access to the location of the RED cell.

However, in FIND and REPLACE, i have a list of results on what I want. But i cannot copied the information out.
So is there anyway to copy it out or to achieve what i want?

For eg.

RED value	cell
50	A3
87	D71
251	AQ5

and so on.

Thank you.