Conditional formating-many text strings

[satucha]

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

novotna
novakova
seredova
jouda

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

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

Thanks
Satucha

[Executor]

Hi satucha

In stead of "Cell Value Is" select "Formula is"

For Cell 'C4' use
=(RIGHT(C4;3)="ova")

Good luck,

Wouter

[johncassell]

Hello, I was looking for something like this and ive just tried that and it didn't work but if you change it to =(RIGHT(C4,3)="ova") then it works.

Notice the semi colon has been changed.

Thanks for putting me in the right direction though!!

[Tushar Mehta]

Whether one uses a comma or a semicolon depends on the regional setting
of the computer.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
>
> Hello, I was looking for something like this and ive just tried that and
> it didn't work but if you change it to =(RIGHT(C4,3)="ova") then it
> works.
>
> Notice the semi colon has been changed.
>
> Thanks for putting me in the right direction though!!
>
>
> --
> johncassell
> ------------------------------------------------------------------------
> johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
> View this thread: http://www.excelforum.com/showthread...hreadid=398972
>
>