However, you can also use other rules like Top/Bottom rules, Data Bars, Color Scales, or Icon Sets to find discrepancies in Excel data. 3] Identify differences using advanced Excel functions.