Excellent! Thanks very much Ken and T. Valko.

"T. Valko" wrote:

Try this:

=IF(OR(A1="",B1=""),"",IF(A1=B1,CHAR(252),CHAR(251 )))

Format the cell font to Wingdings

--
Biff
Microsoft Excel MVP


"Daniel" wrote in message
...
Thanks, that worked but is it possible to use the other tick/cross symbols
in
Wingdings?

Tick character code 252 / 00FC - Symbol (decimal / hex)
Cross character code 251 / 00FB - Symbol (decimal / hex)



"Ken Johnson" wrote:

Oops, I don't know why I put that other And in. Should have been...

=IF(OR(A1="",B1=""),"",IF(A1=B1,"a","r"))

Ken Johnson