Tricky problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having problems trying to get my head around the following. Want to show if
a task has expired or not been completed on time.
I have included a tick box (yes/no) which if ticked would indicate that the
task is completed. But want the system to show those task that have expired
when the report is run.

If DateDiff("mmm", Oct, [Date]) <= True Then
ContractorName.BackColor = 16764057
Else
ContractorName.BackColor = 255
End If

End Sub

I thought using the above means,
if the date in the OCT cell is after the current date then make back colour
for the Contractor name cell ..........

Your help on this last bit will be great
Cheers
 
Hi
You can create a report showing the date difference and then right click on
the text box for the date difference. There is an option for conditional
formatting on there. Try that.
 
Back
Top