Hi everybody,
I'm trying to build a simple search (highlight) function with Conditional Formatting. If I write in
text in a "search-cell" I want all other cells with the same text in that sheet to get coloured.
So far it's quite basic and straightforward.
In the Conditional Formatting Rules Manager I've got:
Formula: =ISBLANK($D$1) with "No Format Set" to clear the format if the search cell is empty.
Cell Value = $D$1 with the format set to fill the target cells with colour if they match the search cell.
This works like a charm.
The problem is that I want two "Search cells" to make it possible to search for two different text strings at the same time. But if I simply make two sets of the above rules they interfere with each other, ie if search cell 2 is empty the search cell 1 does not highlight the cells any more.
I've been fiddling around with "stop if true" and tried rewrite the formatting rules, but to no avail.
Can anyone point me in the right direction here, is there any way to have two search/highlight
functions in one sheet? It doesn't matter if it's in VBA or CF (I'm a newbie to VBA, so I haven't
tried it with this problem).
In the attached file, type something in Search2 (G1) you'll see what I mean.
Bookmarks