I've been puzzling over your problem for a couple of days, and I haven't really come up with a solution.
I suspect that you will need some sort of Visual Basic Macro. Something which changes the properties of the cell when it is active, or highlighted. But I'm not a VB man myself.
Microsoft have very good newsgroup site, (browser based), here where you can search for people who had similar questions, or post a question yourself.
Or perhaps swisse, on these forums may pick this up and give you advice. He's a wiz on VB programming.
I have found a method that might work for you, but it's a workaround, and may need careful tweaking and positioning to get it to look right and work well.
It uses Conditional Formatting, (Format > Conditional Formatting).
You can format any cell's properties to change when a condition is met. So, if you set a cell (or group of cells), to point to a target cell, (note, I don't mean the contents of the cells, just the conditional formatting), and format the cell or cells to change background color if the contents of the target cell equals that of the formatted cells, then the color of the formatted cells wil, change.
Cell A1 is the target cell. In this cell you type in the value or expression you want to search for, instead of using the Find function.
Cells B1 to B5 hold the following values;
Then highlight cells B1 to B5, goto Conditional Formatting, and select Condition 1 "Cell Value is", "equal to", =$A$1, then click the Format button to select how you want the property of the cells to change
You can select Condition 2, (click the "Add" button), to reset the formatting if the target cell is blank, (although it isn't necessary).
In this way, you can use cell A1, (or whatever cell you want), as your Find function, and conditionally format "all" the cells that you need to be highlighted if the contents of A1 matches any of the other cells.
I have just tried a little demonstration and it works, but this may not be what you want.
Let me know if this helps in any way.
Was this reply helpful? (0) (0)