You're welcome. Thanks for the feedback!

Biff

"Rosco" <rosco111NOCAPS@charterNOCAPS.net> wrote in message
news:Xns97BDEB24C93DArosco111@69.28.186.121...
> Biff cried out
>
>> If you have the Marlett font available......
>>
>> Use this formula to get a real checkmark if the cells contain
>> dates and a bold dash (-) if the condition is not met:
>>
>> =IF(COUNT(G5:I5)=3,CHAR(97),CHAR(48))
>>
>> Format the cell as font Marlett.
>>
>> Biff
>>
>> "Biff" <biffinpitt@comcast.net> wrote in message
>> news:eXzF0dlcGHA.4700@TK2MSFTNGP02.phx.gbl...
>>> Hi!
>>>
>>> Here's the formula: (assuming that the dates are true Excel dates
>>> and not just TEXT strings)
>>>
>>> =IF(COUNT(G5:I5)=3,"checkmark","x")
>>>
>>> Why not use the "x" as the checkmark and maybe a dash (-) to
>>> indicate the condition has not been met:
>>>
>>> =IF(COUNT(G5:I5)=3,"X","-")
>>>
>>> Biff
>>>
>>> "Rosco" <rosco111NOCAPS@charterNOCAPS.net> wrote in message
>>> news:Xns97BCE8371AF07rosco111@69.28.186.121...
>>>>I can't seem to figure this one out. I am trying to make either a
>>>> checkmark, someones intials or a check box (reall doesn't matter
>>>> which but check mark would be best) appear in a cell when three
>>>> other cells in that same form contain data. The cells that need
>>>> to be searched woutl only contain dates but the accutall date
>>>> entered is irrelevant to the check box so I would assume that it
>>>> only needs to search for generic data. The dates are entered as
>>>> 05/01/06. Using online help I have been trying and trying with
>>>> "=IF(ISNUMBER(SEARCH("/",AND (G5,H5,I5))),"checkmark","x")
>>>> With that formula i always get the false indicator of x
>>>
>>>
>>
>>
>>
>
> works great thanks!