The following macro goes throughout a sheet in a workbook and finds highlighted cells. When it finds a highlighted cell it clears the contents of that cell. It works well IF the highlighted cell is highlighted manually. However, I often use worksheets with conditional formatting that automatically finds cells with "bad" data and highlights them. The macro won't work for these conditionally formatted cells (which is terrible because these sheets are the reason I wrote the macro in the first place!). If anyone has any suggestions, you'd be a life saver!
Here it is,
Bookmarks