New to macros

[majorun]

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?

 

[majorun]

signature block? thanks for your help

 

[MARK858]

signature block? thanks for your help

The very bottom of my post where the line starts with "Excel jeanie".
The underlined words are links.