Hi all. I have been trying to create a macro by reading all related posts here but I am not experienced with macros, so no success.
What I am trying to do is:
There is a list in column E in worksheet named "Workflow". Users can pick either "BRL", "EUR", or "USD" from this list. Whenever "BRL" is selected, cells in the same row in columns M, N, O, P must show the text "n/a". If the others are selected or if the cell is blank, macro should take no action.
I'm not sure whether this is important to say, but there's a conditional formatting applied to columns M, N, O, P: if "BRL" is selected, neither numbers nor texts can be entered (to prevent users from entering any value that would screw the final result). If either "EUR" or "USD" is selected, then user can enter positive numbers and cannot enter texts. This is already set and working fine. I don't want to over complicate and I think this should not be written in the macro but I don't know whether this would influence macro at all.

Let me know if you guys need more information.

I appreciate any help.