EXCEL : Check if values in adjacent cells/columns are equal, greater or smaller

7: EXCEL : Check if values in adjacent cells/columns are equal, greater or smaller.

Need to compare values in adjacent columns? Easy!
Formulae:
For checking if values are equal: Write =(A:A=B:B) in Cell C2 and press Enter .
For checking if value in cell of Column A is greater than the adjacent value of Column B: Write =(A:A>B:B) in Cell D2 and press Enter .
For checking if value in cell of Column A is smaller than the adjacent value of Column B: Write =(A:A<B:B) in Cell E2 and press Enter .
Drag cells (C2, D2, E2) till the row you want results to be displayed.
Try it out.