Impact on Command Button via Cell Value and Check Box Combined

[Luka_LB]

Hello People,

I have to solve this, I know answer can be time consuming but if you have time and nerves your help will be great.

so, I have

1. YesBOX
2. ForceBox
3. cell Value 'error' or 'OK'
4. and a button 'execute'

Conditions for button when cell value is

'OK'

Button stays inactive
but
color from changes from Black to Gray

YesBOX is Active
ForceBOX is Inactive

cell value is 'Error'

Button stays inactive
and
black


YesBOX is Inactive
ForceBOX goes Active


Conditions for button using boxes

If
Cell Value is 'OK'
and
YesBOX is Checked

Button goes Active


if cell Value is 'Error'
and
ForceBOX is checked

Button goes Active




waiting for your replies and ideas!