Function for getting and setting text color
It is not to complex, I know how to wright the script, but I can't find the functions.
I have a field in which the user can change the Text color. What I want is that the next field gets the same Text color. The next field is a calculated field, so the Text color can not be changed by the user. I can't use the conditional format because I don't know what the user is choosing.
I am looking for a function to get the color of the first field and the function for setting the same color in the next field.
Would appreciate it if someone can help me out.