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