I'm trying to input a product version number into excel in the form of X.X.X
Based on these versions, I have a conditional formatting rule set up when the next iteration is met. The problem I run into is when I have a version, for example 4.6.9 get updated to 4.6.10
Because excel reads the number after the second decimal as the most significant, or because 9>1, my conditional formatting is thrown off. Does anyone know a workaround for this, or some special text rule I could use to have excel evaluate this properly?