Conditional formatting help

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

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
 
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
 
Thanks for responding.
I believe you're right. In my attempt to make it easier, I probably did
complicated it instead.
This is what I really need. Maybe this is actually easier:

Cell A5 would be the date that I placed an order.
Cell J5 would be the date that the order was completed.
If three days go by and the order has not been complete, I would like A5 to
change color to bring attention to the fact that a completed date has not
been entered in J5.

I've attempted this with conditional formatting and have had no luck.

Again, thank you very much for reading.
 
Hi Edward
Maybe I'm way off but have you tried this ( =J5>A5+3 ) it will change red
after or on the third day, just change the number 3 to your choice.
Regards
Cimjet
 
Hi Edward,
I think this is the formula you need in the conditional formatting of A5
=AND($J$5="",$A$5<TODAY()-3)
Remember to set your desired format.
Regards - Dave.
 
Much more simple explanation of your needs and easy to do with CF.

See the other replies for the how-to.


Gord
 
Back
Top