hi all,
i have one file with 2 sheets. right now i manually copy a certain value from sheet 1, press ctrl+F on sheet 2, paste the value, and if i find it on sheet 2 i color the cell where it was found.
can you help me? i have more than 400 values a week (letters+numbers) to test.
thanks alot, Gidi
i have one file with 2 sheets. right now i manually copy a certain value from sheet 1, press ctrl+F on sheet 2, paste the value, and if i find it on sheet 2 i color the cell where it was found.
can you help me? i have more than 400 values a week (letters+numbers) to test.
thanks alot, Gidi