"Mandeep Dhami" wrote:
.. same data in column A and column B,
but in column B the data in not in the same sequence
as that in column A.
.. a formula which identifies if there is
any difference in data of column A with that of column B,
if there is any difference
then the same should be highlighted.

Here's one way to highlight items in col A
which are not in col B via conditional formatting

Select col A
Click Format Conditional Formatting
Under Condition 1, make the settings as:
Formula is:
=AND(NOT(ISNUMBER(MATCH(A1,$B:$B,0))),A1<"")
Click Format button Patterns tab Brown? OK
Click OK at the main dialog

The above will return the required highlights in col A ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---