N niting New Member Apr 3, 2011 #1 HI forum, Is there a way to use countif for comparison purposes as explained in chandoo's post of comparison ninza, where the two columns contain amounts but with minor changes due to rounding off. eg one column contains 819 and other column contains 819.6. Thanks Niting
HI forum, Is there a way to use countif for comparison purposes as explained in chandoo's post of comparison ninza, where the two columns contain amounts but with minor changes due to rounding off. eg one column contains 819 and other column contains 819.6. Thanks Niting
Hui Excel Ninja Staff member Apr 3, 2011 #2 What about Conditional formatting Assuming Columns A @ B Try a Conditional format formula like =ABS(A2-B2)<1.0
What about Conditional formatting Assuming Columns A @ B Try a Conditional format formula like =ABS(A2-B2)<1.0
