I have a csv file (open customer orders) that needs a few things done and I
am wondering how to/best way to accomplish this maybe with macros. I would
like to
1) Sort list based on column A (Customer#)
2) Apply conditional formatting based on contents of column K (Status of
order)
3) Subtotal column N (Order total)

I have set up conditional formatting rules (5) that colors and or crosses
out the entire row based on the status field contents. Now I would like to
automate as much as possible. Can I create a macro that will apply the
conditional formatting (how)? Or is this something that would be better
accomplished by creating a template? The csv file will be consistant in the
columns and incoming file name.