VBA Code: Command button To Change cell backgroundcolor if cell has specific value

[Dedeke]

Hi there, newbie over here not a newbie in excel, but struggling VBA code. In different columns I have cells with a formula which result in a value "X". Some cells results in a number. Is it possible with a command button to change the background of only the cells marked with the value "x" and also for a specific range.
Ex: Ranges worksheet "A1: AB70" only change the color of the cells within the range "Q1: V70"
Already thinking of a second button to remove the colors again if necessary
Hopefully I explained well and did not made to many writing errors.

Already many thanks for even reading my question

 

[Logit]

You will need to change the affected range in the macro but here the first macro creates the color background. The second macro
returns the cell background color to normal.

Option Explicit

Sub CellColorChange()
Dim MR, Cell As Range

Set MR = Range("G6:G12")
    For Each Cell In MR
        If Cell.Value > 5 Then
            Cell.Interior.ColorIndex = 15
        Else
            Cell.Interior.ColorIndex = 0
        End If
    Next
End Sub

Sub CellColorChange2()
Dim MR, Cell As Range

Set MR = Range("G6:G12")
    For Each Cell In MR
        If Cell.Interior.ColorIndex = 15 Then
            Cell.Interior.ColorIndex = 0
        End If
    Next
End Sub

 

[Dedeke]

Logit,
Thx a lot for quick solution. Modified the range to my needs, and also changed the "If Cell.Value > 5" into "Cell.Value = "X" "
because the value X is the one i need in my case.
Tested imediatly: result : SUPER SMOOTH Gonna play arround with the ColorIndex nr. I suppose the colors gonna change depending the nrs I use.

Thx a lot..; (untill the next problem)

 

[Logit]

You are welcome.