Do it in the code that is updating the cell.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Anat27" wrote in message
...
Hi all, I have a cell that its value is changing all the time. i.e., each
10
seconds, mark TRUE. I want to count the number of times TRUE appears in
the
cell. How can I do it?

Thanks a lot