I have 4 ratings : Highly Engaged, Moderately Engaged, Barely Engaged, and Disengaged. What I need is to write a macro that change the text colors in a text box with conditions, and below macro works perfectly fine, however, I need to add another condition, which is "if BE (Barely Engaged)...
I have this macro that should change the text color in a textbox with conditions:
- If value < 3% then change text color to red
- If value > 3% then change text color to blue
- Else color to black
The textbox names are : 2018_Delta, 2017_Delta, and 2016_Delta
The macro changes the font...
My first post :)
I have written a macro to put certain text if conditions are met but now I want the text to color red when the text is either "Please enter Account." or "Please enter Dept/Restaurant." Below is the macro I have written however this is not working. Gives me the error...