tintin1012000
Board Regular
- Joined
- Apr 27, 2011
- Messages
- 237
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
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