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.

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
[TD="class: xl63, width: 64"]ID[/TD]
[TD="class: xl64, width: 64"]Creation Date[/TD]

[TD="class: xl65, align: right"]783393464[/TD]
[TD="class: xl66, align: right"]10/11/2005[/TD]

[TD="class: xl65, align: right"]783393464[/TD]
[TD="class: xl66, align: right"]03/03/2017[/TD]

[TD="class: xl65, align: right"]744976874[/TD]
[TD="class: xl66, align: right"]12/29/2004[/TD]

[TD="class: xl65, align: right"]744976874[/TD]
[TD="class: xl66, align: right"]12/30/2016[/TD]

[TD="class: xl65, align: right"]747485557[/TD]
[TD="class: xl66, align: right"]03/23/2007[/TD]

[TD="class: xl65, align: right"]747485557[/TD]
[TD="class: xl66, align: right"]10/02/2012[/TD]

[TD="class: xl65, align: right"]749387878[/TD]
[TD="class: xl66, align: right"]07/04/2008[/TD]

[TD="class: xl65, align: right"]749387878[/TD]
[TD="class: xl66, align: right"]06/17/2014[/TD]

</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