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

P

Picodillo

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
 
M

Max

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
 
M

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), ...
Click to expand...

It should have read as just:
 
R

romelsb

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.
 
Top