The #N/A isn't a text, it's an error value.

Use the IsError() function in your conditional format (where the cell
whose value you are testing goes inside the parentheses) and it should
work.


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113078