Matching cells with equal values

**LukeBhatia** · 09-14-2011, 10:49 AM

Hi,

Sorry if this is a newbie question! I have tried to use the countif function but as there is not set condition I am having trouble. I think it should be simple enough.

I have two columns of dates - all I want to do is flag any instances when the date in column 1 = the date in column 2

thanks in advance!

L

**Domski** · 09-14-2011, 10:52 AM

Can you post a small sample workbook showing what you are trying to achieve?

Dom

**LukeBhatia** · 09-14-2011, 11:09 AM

06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 13/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010

I have two really long lists of dates as above - and just want to flag up where the date in Column A = the date in Column B

**scottylad2** · 09-14-2011, 11:14 AM

Originally Posted by LukeBhatia

06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/05/2010
06/05/2010 06/05/2010
06/05/2010 06/09/2010
06/05/2010 13/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010
06/05/2010 06/09/2010

Assuming your Data is A1:B10 and you had dates matching as above, what are you looking for? All the dates in Column A would match the two cells i've altered, how would you like that to show or do you wish only the cells that match in Column B to be highlighted?

If you would just like the column B data thats matching highlightes, Highlight the cells B1:B10, open Conditional Formatting, go to new rule, and paste this in =COUNTIF($A$1:$A$12,B1)>1 and format with a colour, then click ok

**Domski** · 09-14-2011, 11:19 AM

=A1=B1 copied down will return TRUE if the corresponding dates match although I suspect that is not what you really want.

It's preferable to attach a real workbook showing the desired result.

Dom