I have many text strings. Some of them ended with specific substring
For example:

novotna
novak*ova*
sered*ova*
jouda

I would like to have cell to go ret color, when string ended t
substring "ova".
In my case, it match strings "novakova" and "seredova".

I think, that conditional formating of cell have to be use. I don
know, which wild-card have to be
use before substring "ova". I think, something like "*ova" ?

Thanks
Satuch

--
satuch
-----------------------------------------------------------------------
satucha's Profile: http://www.excelforum.com/member.php...fo&userid=2662
View this thread: http://www.excelforum.com/showthread.php?threadid=39897