I am 71, a long time user of Excel and am faced for the first time with the need to write a macro!!! I have a worksheet containing reservation data on various rows with various colored backgrounds and text and need all cells from column 2 to last which are not empty and white to be filled red, and text removed with a single macro. Help any one?