thanx for prompt reply. actualy i wanted to do this in a macro so that my
addin can have this feature... any help on this wud of help.

thanx
bahvtosh

"Myrna Larson" wrote:

Excel wasn't really intended as a tool to generate differences between 2 text
files. There are programs available that will do that, however. MS's WINDIFF,
which, AIR, comes with some versions of Office, comes to mind.

On Mon, 21 Feb 2005 01:43:03 -0800, "Bhavtosh"
wrote:

I have two SQL queries pasted in a worksheet and i want to compare these 2
SQLS and highlight the difference with a color.

can u anyone suggest a solution cause im badly stuck and not able to
progress?