You dont mention the method used to determine whether the cell "does not
have any data".

Try this:
=IF(ISBLANK(A1), "check", "ok")



--
Rob van Gelder - http://www.vangelder.co.nz/


"ewagz" wrote in message
...
I have a column of data that automatically updates every half hour. I
looking for a formula that will look at the column and determine if there
is
a cell in that was not updated. For example, I have currently have cells
1D:10D that should all be up to date, but cell 7D does not have any data.
I
want cell 58D to display "Check". Here's where I run into a problem. I
can't have any VB in this worksheet and the sheet is updating every half
hour
with new data (filling in the next time slot). What formula do I use for
this??

Thanks in advance for any insight into this.
--
EW - Analyst