How to highlight the latest time stamp in a given column

[rbysetty]

I have a macro which pastes the username and time stamp, every time a certain macro is used onto a worksheet. If sumitted multiple times, i have another column which identifies that the data has been previously submitted. I am interested in highlighting the row or somehow make the last submission stand out on the worksheet. In other words, the bold rows below need to soemhow stand out. Can someone please help me.


[TABLE="width: 493"]
<tbody>[TR]
[TD]RJ[/TD]
[TD]FemProfile[/TD]
[TD]8/6/2012 18:59[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RJ[/TD]
[TD]FemProfile[/TD]
[TD]8/6/2012 19:27[/TD]
[TD]Previously Submitted[/TD]
[/TR]
[TR]
[TD]RJ[/TD]
[TD]FemImplant[/TD]
[TD]8/6/2012 19:31[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RJ[/TD]
[TD]FemImplant[/TD]
[TD]8/6/2012 19:32[/TD]
[TD]Previously Submitted[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col span="2"><col></colgroup>[/TABLE]

 

[sunnyland]

Why not use the easy way of conditional formatting ?
Selecting all the columns you want highligted then using in conditional formatting [supposing Previously Submitted is in column D] the formula:
=$d1="previously submitted"
then choosing bold
Hope this is helpful.