Conditional formating
 

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

Conditional formating
 

Hi satucha

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

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

Good luck,

Wouter

Conditional formating
 

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

Notice the semi colon has been changed.

Thanks for putting me in the right direction though!

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

Conditional formating
 

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 ,
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