Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formating
Hi satucha
In stead of "Cell Value Is" select "Formula is" For Cell 'C4' use =(RIGHT(C4;3)="ova") Good luck, Wouter |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Worksheet Functions | |||
Conditional formating | Excel Discussion (Misc queries) | |||
If(And for Conditional Formating | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions |