Hello,
I would like to create a macro that will clear the contents of all cells within my worksheet that are of a specific color. My Range is A1:AN400. I want to preserve the formatting, just delete the numbers within the cell.
The RGB is
Red 171
Green 255
Blue 197
Hex: #ABFFC5
I would like to have a button for this macro so that I click it, and it clears all the data within the cells that are this color.
Thank you!
I would like to create a macro that will clear the contents of all cells within my worksheet that are of a specific color. My Range is A1:AN400. I want to preserve the formatting, just delete the numbers within the cell.
The RGB is
Red 171
Green 255
Blue 197
Hex: #ABFFC5
I would like to have a button for this macro so that I click it, and it clears all the data within the cells that are this color.
Thank you!