Search coloured cell in worksheet and list the cell location

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.

Originally Posted by rcm

try this workbook

thanks for your reply.
But it seems didnt really work when i m applying on my spreadsheet.

please find what i attached.
so i wish can do a red cell search and complete column A,B and C. so i can easily add a hyperlink column next to it.



And As if there is anyway that after clicking the hyperlink, the detestation cell will be zoom in and center.