I would like a way to automatically mark (color, add a character to the beginning of the contents, whatever...) every cell in a worksheet that matches a particular value.
I have a spreadsheet that is 8000 lines long and I have to look up the contents of each of the cells. Some of the cells are repeated, so I would only have to look them up once, but as soon as I passed 100, I couldn't remember what I had seen already. Is there a formula or a macro I can use to mark the cells that match the ones I've already seen(even if I have to add the entry manually every time) such as "find all the cells that have contents = "bear" and make them yellow (or prepend an xxxxx to the contents, etc)?
Thanks!
2007-07-17
07:31:33
·
3 answers
·
asked by
kw
2