I’m having trouble with the following:
How can I change the content of a comment based on the value of a specific cell? I have a spreadsheet that is supposed to be used by both speakers of Dutch and French. With a simple IF()-formula I was able to translate the language content in the regular cells based on the value of a specific cell (‘Dutch’ or ‘French’) that the user can select using a drop-down box. Now the entire spreadsheet is translated except for the comment boxes.
Any help would be very much appreciated.
Thanks in advance,