Change Column of Data From Number to Currency Based on Header

[Yoandsm]

Hello,

I was wondering if there was a way, maybe by conditionally formatting or a Macro if needed, to find a specific Column Header and then format all of the cells under that to a certain format.

As a specific example, I would like to find "$" in row three, and then format that whole column to Currency.

I'm not sure if this requires a macro, or if I am missing something obvious with conditional formatting, but I would appreciate any help that you can provide.

Thank you!

[leelnich]

Hi Yoandsm, yes, assuming your headers are in row 3, you could use this conditional formatting formula (in A4 and copy):
=ISNUMBER(SEARCH(A$3,"$"))

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[Yoandsm]

Great, thanks so much! That was very helpful