Hello,
I am trying to use conditional formatting to detect when two cells have different values. The formula is quite simple: =G50 <> G58 . I want Cell G58 to become red when its value doesn't match with that in G50.
The problem is the Cell G58 is always showing red, except when I enter the same number in both cells manually, for example 0 or 10.
Both cell G50 and G58 have formulas. On further investigating, I realized that the values in both cells match up to the 7th decimal place, but the eighth decimal digit is different, as shown below. As my numbers are in millions, I never use decimal places, that is why I never noticed the difference.
G50=1,429,151.418375630
G58=1,429,151.418375620
How do I get Excel to ignore that kind of minor difference? Also, is there a way to reduce Excel's precision to only, say, 3 decimal places?
I have Excel 2010.
I am trying to use conditional formatting to detect when two cells have different values. The formula is quite simple: =G50 <> G58 . I want Cell G58 to become red when its value doesn't match with that in G50.
The problem is the Cell G58 is always showing red, except when I enter the same number in both cells manually, for example 0 or 10.
Both cell G50 and G58 have formulas. On further investigating, I realized that the values in both cells match up to the 7th decimal place, but the eighth decimal digit is different, as shown below. As my numbers are in millions, I never use decimal places, that is why I never noticed the difference.
G50=1,429,151.418375630
G58=1,429,151.418375620
How do I get Excel to ignore that kind of minor difference? Also, is there a way to reduce Excel's precision to only, say, 3 decimal places?
I have Excel 2010.
Last edited: