I have a Field "Bandage" set up as a radio-button field with three values 1,2,3.
Field "Left" and Field "Right" are edit box fields.
When the value of "Bandage" is 1, I would like Field "Left" to be highlighted or Field "Right" to be greyed out.
When the value of "Bandage" is 2, I would like Field "Right" to be highlighted or Field "Left" to be greyed out.
When the value of "Bandage" is 3, both fields could be filled.
This is just to remind the user on how to fill the fields and prevent mistakes, I do not need to make it impossible for user to enter text in Field left or Right based on selection of value.
I am not typing the formula in Conditional Formatting correctly. Can you help me with the calculation?