Conditional Formatting with dates

[RaganSpringer]

I have a database that tracks the fuel purchases for a company and I need a report to highlite any employees who have multiple transactions on the same date. I believe that I can use conditional formatting to do this, but how do I get it to check if the date on a a single record is equal to the date on another record for the employee?

[ADezii]

I have a database that tracks the fuel purchases for a company and I need a report to highlite any employees who have multiple transactions on the same date. I believe that I can use conditional formatting to do this, but how do I get it to check if the date on a a single record is equal to the date on another record for the employee?

You have provided so few Details so the only thing I can do is to show you the basic Logic and where and how to apply it. In the Format() Event of your Form, place the following code and make any necessary substitutions:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If DCount("[some date]", "transactions table", "[some date] =  " & Me![date on report]) > 1 Then
  Me![LastName].ForeColor = QBColor(15)     'Bright White
  Me![LastName].FontBold = False            'Regular Font
  Me![LastName].BorderStyle = 1             'Solid Border
Else
  Me![LastName].ForeColor = QBColor(4)      'Red
  Me![LastName].FontBold = True             'Bold Font
  Me![LastName].BorderStyle = 0             'Transparent Border
End If
End Sub