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!
Bookmarks