Macro to apply format to cells in same row, different column

Hi all,

Attached is a sample Workbook. I need a macro that allows me to go through the contents of column "I" (in sample book, the one called "Dec") and, for each occurrence of the pound symbol (#), go to column A in the same row, and apply a color to that cell and make it bold. I'm gonna be using this macro in sheets, each having different quantity of rows, but the number of columns will always be the same, and the "Dec" column will always be in the same position. Also, I need the macro to not take in consideration the book's name, since I'm gonna be using it in different workbooks and computers.

From an attempted macro I recorded, this is the info about the color I need: .ThemeColor = xlThemeColorLight2
.TintAndShade = 0.599993896298105

Hope this is enough info.

Thanks!

Try this

Please Login or Register  to view this content.

Hi Brad,

Thank you so much for your help! The macro worked as expected. However, I have a question. What does need to be changed in order to make it work with any sheet regardless of the name of it (or the book)?

Thanks!

Originally Posted by axtryo

Hi Brad,

Thank you so much for your help! The macro worked as expected. However, I have a question. What does need to be changed in order to make it work with any sheet regardless of the name of it (or the book)?

Thanks!

No problem, change sheets("sheet 1") to activesheet

Brad,

I truly appreciate your help. Now the code works as desired. I'm marking this post as solved.

Thank you so much.