i'm tracking about 450 people, i have a excel sheet filled with drop downs, but what i'm looking is a formatting that once i enter a name in column A it will change the color of the whole row. the issue that i find excel wants specific data and not just any name. I think i need 2 rules for my...