Formating for Look Ahead

[traha]

Extra to yesterdays question

I have set a condition in b1 so that when I enter a date in b1 I want it to reference a1, and return blue text if it is less or equal, and red text if it is greater.

I now want to set a further condition so that a1 changes to red text if no date has been entered by 5 days before the date in a1

Thanks in anticipation

 

[beminaga]

you can use a user defined function in such as:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B1")) Is Nothing Then
Exit Sub
Else
Range("A2") = Now 'or any blank cell in which the last input time_
will be recorded
End If
End Sub

' this function should be added in the related sheet in VB editor (press "Alt + F11")

and for example in cell A3 you may write (maybe with white fonts not to be seen):
"=IF(DAYS360(A2;NOW())<5;"";"A1")"
and now you can conditionally format A1 acording to A3, such as if A1 = A3 color red.

hope i didn' misunderstand your question!