Clearing multiple cells specified by beckground color or any idea how to do this quickly

[bartek158]

Hello
I try to resolve some problem. I use one workbook with about 20 worksheet. When I start to calculate new data I have to celar many cells in all of this sheets, tis cells are in many areas of sheets. I do this manually. I was thinking is this posiible to to clear data using VBA for example only in cells with specific background color ? It will be easy tu use in future when I will make some modifications in workbook. I will have to make only one think to do - change beckgraund color in specific cells.
Or mayby somebody have other idea how to make excell user more easy ?
Best Regards

[jolivanes]

This would clear the cells with a value < 0 in all sheets.

Please Login or Register  to view this content.

And this would clear the Value and the Cell color if the fill is red.

Please Login or Register  to view this content.

[Akuini]

This code will clear the content of cells with yellow background & then clear the background color. It uses loop only for iterating through worksheets but not for the replacement part, so it should be faster.

Please Login or Register  to view this content.