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