In tracking an employee's commission, I'd like Excel to automatically assign a color depending on their sales. Say an employee needs to make $100 in sales every shift. Can I make it so that when the employee makes <$100, the cell is automatically colored red? Is this possible?