find and highlight VBA

[tintin1012000]

Im looking for a bit of code to search for whats in cell C27 and highlight each cell that matches it, with a colour eg yellow
the problem is that the contect of C27 is a formula ''='Issue - Weekly'!A1'' which has result of ''DInger'' and the rest of the sheet is also formula based

so its not as easy as searching for DInger , you have to search for the result of ''='Issue - Weekly'!A1

 

[SteveO59L]

how big is your searchable range?

 

[tintin1012000]

how big is your searchable range?

a1:cc80