On Fri, 7 Oct 2011 19:18:10 -0700, "joeu2004" wrote:

"Ron Rosenfeld" wrote:
On Fri, 7 Oct 2011 14:40:33 -0700, "joeu2004" wrote:
Also, you cannot use Conditional Formatting to accomplish this in XL2003.

I'm surprised. I thought you could format font color in CF in XL2003.

Who said anything about font color?

Perhaps I misunderstood. When you wrote:

Also, you cannot use Conditional Formatting to accomplish this in XL2003.

I thought that by "this" you were referring to the OP's request to:

display a blank cell if the cell value is text "null"