I want to make a macro in Google sheet for the following case
In a worksheet column, say column J, The allowed text inputs are "A", "B" and "C".
As soon as I put
C (in the
Jth column) the cell background color should change to "Green", "Yellow" & "Red" respectively.
How can I do that?
I don't know much about macros, I just got the task to do so. Can I get some help?