[Excel 2007] Apply custom number format based on column header

[woody3737]

I have 4 different custom number formats that I use for various columns of data, one for currency, number, retail price, and percentage. I was wondering what the code might look like to have a macro search the column headers, in row 3, and based on what the column header is, it will apply a certain format, either to the entire column or just to the cells containing data. Either way would be ok. For example, if a column header is POS Sales, I would like it to apply the following format to the column:

"$#,##0_);[Red]($#,##0)"

I believe I'd be able to alter any suggested code to take into consideration all of the other header names. Thanks for any help.

 

[woody3737]

I failed to mention that the header could also just contain POS Sales, such as "2008 POS Sales" & "2009 POS Sales"