Any 72 consecutive hours?

Starting when?

What if someone entered something then deleted it an hour later?

Would that re-start the three day period?

You would need some type of event code to watch J5 to reset the counter in that
case.

I don't think it is "probably very simple" but I may be over-reading this or you
have not described exactly what you want.


Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 16:30:54 -0400, "Edward" wrote:

Hi,

I can't figure out the way I should create this conditional formatting. It's
probably very simple though.

If a cell, let's say J5, is empty for three days, then the background of
cell A5 turns red.


Any help would be appreciated

Thanks