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.
Hello,
I'm not sure that this is documented anywhere. My experience is that the colour coding in the formula references is strictly on a left to right basis. The first reference to a cell, range or named range will be blue, the next one red, and so on. If a reference is used more than once in a formula, each mention of that reference will get the same colour as the first mention of that reference. If cell addresses are used interchangeably with range names, they will get the same colour assigned.
Does that help?