aayaanmayank
Board Regular
- Joined
- Jul 20, 2018
- Messages
- 157
Hi Can someone please help me, i need a vba code where it should green color on oldest date with in one ID.
below is the sample of data.
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]ID[/TD]
[TD="class: xl65, width: 64"] Date[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]338583883[/TD]
[TD="class: xl67, align: right"] 08/11/2005[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]338583883[/TD]
[TD="class: xl67, align: right"]06/23/2003[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]352556553[/TD]
[TD="class: xl67, align: right"]06/16/2008[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]352556553[/TD]
[TD="class: xl67, align: right"]09/16/2008[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]855585635[/TD]
[TD="class: xl67, align: right"]07/22/2015[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]855585635[/TD]
[TD="class: xl67, align: right"]09/30/2017[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]855585635[/TD]
[TD="class: xl67, align: right"]09/30/2017[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]853523322[/TD]
[TD="class: xl67, align: right"]09/27/2016[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]853523322[/TD]
[TD="class: xl67, align: right"]06/21/2012[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]828533758[/TD]
[TD="class: xl67, align: right"]03/24/2009[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]828533758[/TD]
[TD="class: xl67, align: right"]09/11/2017[/TD]
[/TR]
</tbody>[/TABLE]
below is the sample of data.
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]ID[/TD]
[TD="class: xl65, width: 64"] Date[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]338583883[/TD]
[TD="class: xl67, align: right"] 08/11/2005[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]338583883[/TD]
[TD="class: xl67, align: right"]06/23/2003[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]352556553[/TD]
[TD="class: xl67, align: right"]06/16/2008[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]352556553[/TD]
[TD="class: xl67, align: right"]09/16/2008[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]855585635[/TD]
[TD="class: xl67, align: right"]07/22/2015[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]855585635[/TD]
[TD="class: xl67, align: right"]09/30/2017[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]855585635[/TD]
[TD="class: xl67, align: right"]09/30/2017[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]853523322[/TD]
[TD="class: xl67, align: right"]09/27/2016[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]853523322[/TD]
[TD="class: xl67, align: right"]06/21/2012[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]828533758[/TD]
[TD="class: xl67, align: right"]03/24/2009[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]828533758[/TD]
[TD="class: xl67, align: right"]09/11/2017[/TD]
[/TR]
</tbody>[/TABLE]