Loop to clear cell contents by column (but not entire column)

Hello,

I am trying to run a loop where if a cell contains "Good" then that cell as well as two adjacent cells in the same column will have their contents cleared. To be more clear, here is an example:

Good Good Check Good Good Good
A B C D E Total
155 0 14 153 89 411

In this case, I would want the cell contents of A1:A3, B1:B3, D1:D3, E1:E3, and F1:F3 cleared but the contents of C1:C3 to remain. I do not want to delete an entire column or shift any cells.

How would I go about doing this?

Thank you,
Cody

Please Login or Register  to view this content.

Kind regards
Leo