highligt duplicate value conditional formatting.

[newapa]

Hi!

i'm new in vba. and i can nothing about conditional formatting. so i wonder if some one can help me with the conditional formatting. that marks duplicated value in 2 column. something like this.

column B    column C           column D       column E       column F         column G
nameA       2012-03-03       00:05:09       nameA           2012-03-03     00:05:09
nameB       2012-05-06       08:06:07       nameB           2012-05-06     08:06:07
nameC       2012-04-05       05:01:22       namec           2012-04-08      05:01:22

thx in advance

 

[Andrew Poulsom]

Aren't all those duplicates? Please post some sample data with duplicates and non-duplicates.

 

[newapa]

i have a folder there is about 600 files. and i have copied all the file to another folder. and i have listing all this file in to exel and wanted to check if the file name and time and size is the same. and i found out there is one with different time. so i need a conditional to check that name have same name date have same date and size have same size. som i can se whitch one is the one that not have the same date or size.

here some sampel data

bare1237.sdv	2012-09-16 22:25	32705			bare1237.sdv	2012-09-16 22:25	32705
bare1238.sdv	2012-09-21 10:26	23756			bare1238.sdv	2012-09-21 10:26	23756
cphdkk12.xls	2012-09-20 12:36	117248			cphdkk12.xls	2012-09-20 13:00	117248

thx

 

[Andrew Poulsom]

Select all your data and apply a conditional formatting formula like:

=AND(EXACT($B1,$E1),EXACT($C1,$F1),EXACT($D1,$G1))

Take care to have $ signs before each column reference.

 

[newapa]

Hi andrew. thx a lot. it working fine.

but can u help me with one more conditional. i tried to creat a conditional the formula is like this. =And(0,02 > ($E1-$B1);0,009<($E1-$B1))
but it mark alla in column b and e white. i wanted that if time in column E is newer then column B between 0 to 30 min it will be green. but B can't be newer then E. as u can se B is 12.36 is old time. but E is 13.00 is newer time than 12.36.

cphdkk12.xls	2012-09-20 12:36	117248			cphdkk12.xls	2012-09-20 13:00	117248

thx

 

[Andrew Poulsom]

Try:

=AND(($E1-$B1)>="00:00"+0,($E1-$B1)<="00:30"+0)

 

[newapa]

Hi Andrew!

And thx agian.
its fix now :D

big thx

best regard
newapa