highlight if the date match

[darkhangelsk]

is there any way that i can match the date in a data and apply a color if match?

sample:


column a2: 11/5/09 $15.00

column b2: 11/5/09 house $15.00 -> then the column B2 must be filled with color because they have the same date with the column a2.

Thanks.

[davesexcel]

There are many thread in this forum on Conditional Formatting

[darkhangelsk]

I attached a sample to make it more understandable

Thanks..

[NBVC]

Select the column C range and then invoke conditional formatting through Home|Conditional Formatting|New Rule

Select Use a formula to determine which cells to format and enter formula:

=SUMPRODUCT(1*(ISNUMBER((SEARCH(LEFT(C1,FIND(" ",C1)-1),$A$1:$A$3)))))

change $A$1:$A$3 to suit your lookup range...

Then click Format and choose color pattern.

[darkhangelsk]

Thanks NBVC! you got it perfectly!