Format column based on column header

I am constantly having to format new excel spreadsheets, most are completely different. I have a script that formats the spreadsheet to an extent, but I need a way to format columns based on the column header. If a column has "$" or "total" or "amt" or any other key word that could mean currency, I want that column to be formatted to currency. Right now, those columns are manual and there could be many of those in a particular spreadsheet. Can this be done, maybe with "Case"?