Flag cells that are empty after 90 days

**SpiritedAway** · 06-11-2013, 02:03 PM

In my worksheet there are 4 columns - A, B, C, D.

If no date is entered in Column B 90 days after entering a date in Column A - Column B should be flagged up (conditional formatting I think).

&

If no date is entered in Column C 90 days after entering a date in Column B - Column C should be flagged up

&

If no date is entered in Column D 90 days after entering a date in Column C - Column C should be flagged up.

Is there a way of doing this? I have googled around but nothing that works for what I need above.

Any help would be greatly appreciated. I'm using Excel 2007.

**etaf** · 06-11-2013, 02:12 PM

is it 90 days from the date thats entered
or is it the date the actual information was typed into the cells ?

=and(B2="", A2<today()-90)
that will check if the cell B2 is blank and A2 date is more than 90days after today

but it sounds like you need the date the info was entered - so some form of vba would be needed- not my area

**SpiritedAway** · 06-11-2013, 02:37 PM

Its 90 days from when the date is entered into the column.

So if I entered today's date in cell A2 in Column A and 90 days passes and no date has been entered in cell B2 from the date I entered in A2 - B2 is flagged up.

If I entered a date in B2/Column B and 90 days pass and a date hasn't been entered in C2 then C2 gets flagged and so forth.

**etaf** · 06-11-2013, 02:49 PM

Use a formula conditional format

so a conditional format in column B
AND(A1<>"",B1="", A1<TODAY()-90)
and column C
AND(B1<>"",C1="", B1<TODAY()-90)
and column D
AND(C1<>"",D1="", C1<TODAY()-90)

should all work
see attached

you may not want the first
A1<>""
or
B1<>""
or
C1<>""

if that is not added then all the columns will highlight when no data entered

so you can remove that if needed - and then all cells highlight before any data entered

**SpiritedAway** · 06-11-2013, 02:56 PM

Etaf this is exactly what I was looking for! Your time and help is greatly appreciated. Thanks!!

**etaf** · 06-11-2013, 03:01 PM

your welcome
the blanks is not a good test after all

as no date entered needs to be flagged
so a conditional format in column B
AND(B1="", A1<TODAY()-90)
and column C
AND(C1="", B1<TODAY()-90)
and column D
AND(D1="", C1<TODAY()-90)

so now all blank cells highlight - but we may need to play with that a bit more when used for real
you dont want C or D highlighting if blank , as it will be to start with

but have a play and see

then if a sample spreadsheet can be uploaded