Forum Discussion
Excel Formula Color Coding Logic
Is there any documentation as to the color coding logic Excel uses when applying color to a formula during edit mode? (see example below) I create training material and like to preserve th...
Thank you for your reply. I understand what the colors are and how they repeat, my question lies in which variables get which colors; i.e. variable's order within a function, function order, function depth within the formula, etc... I know it's an odd question, but I have to assume that someone at some point mapped all of these rules out in order to program them into Excel.
As Ingeborg says: there is no logic other than a simple left-to-right order of appearance in the formula, with one exception: repeating references have the same colour as their first appearance.
Note that the colors are different for other versions of Excel. I picked up the colors from my Excel 2016. Those appear to be less intense than the colors of Excel 2010.