Help formatting an overdue column however want blank if source cell is blank

[Samantha12]

Hi,

i have a column which is formatted to populate an overdue when a date is less then today. When I drag the formate down it populates overdue as there is no date currently.

How to i I keep the formate however when the source cell is blank the formatted blank remains blank too?

sam

 

[Aladin Akyurek]

What is the formula you have?

 

[Samantha12]

What is the formula you have?

Column A1 You place a date in yourself
Column A2 = A1+7
column A3 =today()
Column A4. =if(A3<A2,”OVERDUE”,””)

The issue I have is I want to build a big spreadsheet and lock the formatted Cells so they don’t have to drag formulas as each entry. As column A1 won’t have a date in it all the time the overdue will sit there.

I want to drag the formatting down however want the over due to populate only when the source cell has dates in there and is actually overdue