I need some cells to clear when the value of another cells changes. This macro works but I have conditional format to change colors.
So I am looking for a way to clear a cell when the "Value" of a different cell changes "&" if the Cell "Color" turns Pink, Blue, Green, or Purple?
If Not Intersect(Target, Range("B29:O113")) Is Nothing Then
Range("H121:H123").ClearContents
End If
My objective - when the value of a cell changes and those changes turn Pink, Blue, Green or Purple then clear some other cell (not sure how colors are written because mine are kinda off shades).
So I am looking for a way to clear a cell when the "Value" of a different cell changes "&" if the Cell "Color" turns Pink, Blue, Green, or Purple?
If Not Intersect(Target, Range("B29:O113")) Is Nothing Then
Range("H121:H123").ClearContents
End If
My objective - when the value of a cell changes and those changes turn Pink, Blue, Green or Purple then clear some other cell (not sure how colors are written because mine are kinda off shades).