Conditional formatting

[Awheaton]

Hi,
I have a spreadsheet that performance data is imported into from two different sources. The main goal is to see when the two data entries do not match. However, the two data sources are never rounded to the same decimal place. For instance performance from 1/31/2017 will be 1.3245687% vs 1.3245%. Although I format both columns to 2 decimal places, excel still isn't able to recognize that the two rounded 1.32% entries are equal.

I'm currently using a conditional formatting formula =Round(B2,2)<>Round(C2,2) to highlight column C when the adjacent B cell does not match. However, it doesn't seem to be working very well.

Any help is greatly appreciated. Thanks!!!

 

[StephenCrump]

I'm currently using a conditional formatting formula =Round(B2,2)<>Round(C2,2) to highlight column C when the adjacent B cell does not match. However, it doesn't seem to be working very well.

Welcome to the Forum!

Try using Round( ... , 4)

Otherwise, for example, Round(1.7%,2) <> Round(2.3%,2) will return FALSE, i.e. because they are both equal to 0.02 to 2 dp.