Highlight if there is a difference

Closed
Shavon - Nov 11, 2010 at 10:04 AM
data_encoder Posts 13 Registration date Wednesday November 3, 2010 Status Member Last seen November 15, 2010 - Nov 11, 2010 at 06:54 PM
Hello,

I am trying to highlight every row that has a difference. I need a macro that will perform this task. I am looking at col E. Some lines of data are duplicate but has a difference in col K.

3010016907 TOWNHOUSE REDUCED FAT CRACKRS 13 OZ 41 71 $0.50
3010016907 TOWNHOUSE REDUCED FAT CRACKRS 13 OZ 41 71 $0.44




Can any one help me with this?

1 response

data_encoder Posts 13 Registration date Wednesday November 3, 2010 Status Member Last seen November 15, 2010 1
Nov 11, 2010 at 06:54 PM
Do you have a fix amount of columns? Is the macro suppose to check each column and compare, or just on column E and K? A sample of your data on a worksheet would be more helpful.
0