I have attached an Excel 2003 workbook that I need help writing a VBA for. I need the row to be highlighted a certain color depending on if they are below Tier 0, at Tier 0, Tier 1, Tier 2, which the result is in cell AD4-7, I would also like to row to be highlighted in a different color if they reached Tier 0-2 but cell AG4-7 shows "disqualified". I currently have the row being highlighted through conditional formatting, however with 2003 it only allows 3. Thank you in advance for any help!