Hi,

I have a spreadsheet with a column for Department that contains numbers. I
would like to be able to sort by Department and then use vba code to name a
range for each department number and then use the range name in conditional
formatting. This is something that I have to do on a weekly basis with a
new list downloaded to Excel, so I would really like to automate as much as
I can. Is this possible?

Thanks in advance for any help.
Pam