Change the Conditional Format Color of a Text Field Using a Button

[CJBills]

On a form, a text field has the three color conditions allowed in the Conditional Formatting dialog box.

OBJECTIVE:
I need a button to change the color of the text field from one of the three to a new color condition (grey).

RESEARCH:
In my research I have found a delete condition (I believe: Me![txtFieldName].FormatConditions.Delete), which hasn't worked, and a I'm not sure if deleting conditions is necessary. A lot of coding I've found includes If/Then statements, which do not seem to apply (except for If [you press this button] Then [that field will change from whatever color it is to Grey].

Any suggestions would be gratefully appreciated.
Thanks, in advance.

 

[Gary McMaster]

Maybe this:

In your button "Click" event:

Dim oFormat As FormatCondition

On Error Resume Next
   For Each oFormat In ActiveCell.FormatConditions
        oFormat.Interior.ColorIndex = 15
   Next oFormat
On Error GoTo 0

 

[CJBills]

Thanks, Gary McMaster. I was not able to get it to work. Although it led me to the following solution.

SOLUTION:

Private Sub GreyTextField_Button_Click()
    
    Text1.BackColor = RGB(191, 191, 191)

End Sub

Thanks, again!!!!
This is getting awesome.

 

[Gary McMaster]

Although it led me to the following solution.

OK, I'd say I couldn't have misinterpreted your question any more completely but it's good to hear you got it working. Thanks for the feedback.