Color code on oldest date

[aayaanmayank]

Hi Can someone help me with below data. i need to color code whichever is oldest date for particular ID.

ID	Creation Date
783393464	10/11/2005
783393464	03/03/2017
744976874	12/29/2004
744976874	12/30/2016
747485557	03/23/2007
747485557	10/02/2012
749387878	07/04/2008
749387878	06/17/2014

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Special-K99]

=MIN(IF(A1=A$1:A$8,B$1:B$8))
Array formula, use Ctrl-Shift-Enter

produces the oldes date per ID.

Select the entire range (both ID and dates)

Conditional Formatting
New Rule
Use a formula to determine...

=($B1=MIN(IF($A1=$A$1:$A$8,$B$1:$B$8)))

Format as required

 

[Peter_SSs]

Hi Can someone help me with below data. i need to color code whichever is oldest date for particular ID.

If your sample data is representative (oldest date is the first row for each ID) then you could use this much simpler Conditional Formatting formula after selecting A2:Bxx

Excel Workbook
	A	B
1	ID	Creation Date
2	783393464	11/10/2005
3	783393464	3/03/2017
4	744976874	29/12/2004
5	744976874	30/12/2016
6	747485557	23/03/2007
7	747485557	2/10/2012
8	749387878	4/07/2008
9	749387878	17/06/2014
Oldest Date (2)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =$A2<>$A1	Abc