Interior.Color RGB Values Misaligning

Good Afternoon,

I have the following bit of code written to detect the interior color of a cell, break it into RGB, then change the fill of another cell to that RGB value.

However, when double checking that it was working properly I noticed that Interior.Color of the target cell does not actually match Interior.Color of the source cell.
Additionally, if using this code to check the RGB of a blank cell, which should come back as (255,255,255), it instead comes back as (255,0,0)

Please Login or Register  to view this content.

I am attaching the sheet as well, so you can see the exact test color that is not lining up.

I am not sure what about this formula is incorrect. Other sources online confirm this approach to finding the correct RGB value.

Thank you very much. I appreciate learning the difference between those operators.

Good way to learn different things but this works and is easier.

Please Login or Register  to view this content.

Hi Marc,

This is feeding into a larger sheet where the comparison input given will be in terms of integer values for the R, G, and B components. With the input being given in those terms, my process was to then break the visual cells down to those same components and confirm a match or, if not a match, the exact deviance on each of the RGB parameters.

Hope this answers your question.