I have a worksheet with about 1800 rows and multiple columns. In one particular column, the cell MAY contain a hyperlink. I accidentally removed the hyperlink style (by trying to get rid of a conditional formatting rule ) and now all the cells in the column have the same plain formatting whether they contain a hyperlink or not. Instead of formatting each cell individually, can I create a macro that will check if the cell contains a hyperlink and if so, apply the hyperlink style? How do I do this?
Thank you.