How do I determine the color of a cell equal to another, example: A4 is then C2 is cyan color cyan. A2 is then C2 orange color is orange.
There is no excel-formula to get you the color of a cell, nor is there one, to set the color of a different one.
However, you can make a function to get the color of a specific cell - or, like in my example, the color of the function-calling cell:
Now you might, think, ok then I modify this, just to SET the color too. But no - does not work that way. In order to change a cells color, you would have to use
Would be the line for that, when using
You can of course use
here is some C# code, maybe it could be helpful to you: