how do i highlight a date that is 4+ days old in excel?

[Guest]

I am creating a sales tracking type spreadsheet. I am looking for a formula
that will automatically highlight cells that are older than 4 days, only if
there is no date in the cell to the right of it. The formula should
automatically update as the current date changes and should remove the
highlighting when a date is entered in the next cell to the right

 

[Guest]

This might suffice ..

Assume real dates running in A1 down. Select cols A and B (select the col
headers A to B, this ensures that A1 is active), then click Format >
Conditional Formatting. Under Condition 1, make it as:
Formula is: =AND(A1<>"",TODAY()-A1>4,B1<>"")
Format to taste, OK out

 

[Max]

Sorry, there's a correction to the line:

.. Select cols A and B (select the col headers A to B,
this ensures that A1 is active), ...

It should have read as just:

Select col A (select the col header A, this ensures that A1 is active),
...

---

 

[Guest]

Try this Mr Pic....My assumed constraints from ur ?
1. Highlight date which is older by 4 days from today.
2.only one cell in a row can have a highlight.
3.one row = one customer.
4.no typed character in a cell other than the date <in adate format>


Try type this <conditional format window - formula condition> in cell B2
=AND(C2=0,B2<(TODAY()-4),B2>0)
pick color for highlight.