Comparing multiple criteria in excel

Query Photo. Sl. No. Invoice No. AWB No. Dispatch Date Reason for delay 1 A1 BD123 02/02/2016 On Time 2 A1 BD123 02/02/2016 Delay

In above example, i want the following done:

If i have same invoice No. and AWB No., if the dispatch date entered are different, it should highlight it. Also, for same condition, if there are multiple reasons, it should highlight it.

In example above, the same invoice number dispatched against same AWB no. can either be On time or Delayed and thus having two different reasons for same entries should get highlighted.

Thank you very much in advance. Saurabh Singh