Excel 2007 : Conditional Formatting: Multiple conditions

All,

I am new to the Forum and thank you all in advance for your help. I am fairly adequate with Excel, but Programming and macros are my ignorance.

I am trying to simplify my life and write a code that when I paste data from a report it will extrapolate out to the corresponding sheets based off of the data it needs. Example is as follows, all US State Based info:

I will paste data into "Master Leads" Worksheet, Any leads from states ID, MT, OR, & WA, the row associated with that state gets copied to Worksheet "Agent 1". Each Agent worksheet getting leads from their respective territory which i can add in myself, I just don't even know where to start.

Again, I appreciate all help and knowledge on the subject, if this is of no challenge to you that is great, I may have some VPN reporting questions in the near future.

Thanks to all!