Make tick appear
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
|