Hello,

I'm creating an internship recruitment roster, and I'm looking to program the sheet to do a few things automatically:

1) Every intern is labeled with a status letter under a "Status" column, such as A for hire, for F for fail. I would like to program the sheet to automatically assign the row of a given letter the color I designate, and put a border around it. Unfortunately, there are more letters in use than conditional formatting can keep up with.

2) Every time I enter a new person in the system (by typing in their status letter), I would like the sheet to automatically sort itself in a given range (all cells except my headers, which range in row from 1:A-1:N

Thank you!