Can someone suggest a simple routine routine to do the following with an array.
The array is 10x12. Each cell in the array has a letter in it.
What I would like to do is type in a letter, F for example. Then every cell which contained F will highlight. I would repeat with more letters and they would highlight also. Each letter would be highlighted with a different color.
I don't know visual basic so I am hoping I can do this with regular excel formulas.
I don't need prompts or any dialog. I am good with just typing info into a cell.
I know simple stuff on excel and have used a few formulas but this particular thing I don't know how to do.
Bookmarks