Question about an argument

Could someone tell me how it would be possible to have an argument that
is a color and have it accepted as either the number representing the color
or a reference cell from which the color is copied.

I think that I will need to identify what variable type is entered for the argument.

Thank you for your help.

Hi

Probably be best to either specify the argument type with a second argument.

An alternative is to have the default as being one option, and have a second optional argument that is invoked if you don't want to take the default option.

rylo

Normally I would agree .

But I have 2 colors.

If I specify only one color the all rows are color1, if I specify two colors then the colors alternate.

If I provide two options for variable types, my If statements are going to get
complex.

Maybe if I give that some thought I can make that work.

Thank you for replying.