Conditional Formating?

[Jman]

OS Vista
2007 Excel.

Column A down
i have dates..
How can i get the most recent date automatialy highlighted?

 

[Max]

Assuming real dates in A1 down,
In xl2003, these steps would do it:
Select col A (ie A1 active)
then apply conditional formatting using Formula Is:
=AND(A1<>"",A1=MAX(A:A))
Format to taste, ok out

Maybe you could try a similar play in your xl2007 ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:55
xdemechanik

 

[Sheeloo]

I tried with =D1=MAX($D$1:$D$55) and it worked for me (Excel 2003)

 

[Rick Rothstein]

What happens if all the cells are empty?

 

[Jman]

Assuming real dates in A1 down,
In xl2003, these steps would do it:
Select col A (ie A1 active)
then apply conditional formatting using Formula Is:
=AND(A1<>"",A1=MAX(A:A))
Format to taste, ok out

Maybe you could try a similar play in your xl2007 ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:55
xdemechanik

Thanks it worked

 

[Jman]

I tried with =D1=MAX($D$1:$D$55) and it worked for me (Excel 2003)

Thankx i'll keep this formula in mind if i switch back to (excel 2003)

 

[Sheeloo]

Then the whole column will be highlighted... I prefer that to supressing it
with testing for blank...

 

[Max]

Welcome. Do take a moment to rate responses which help by pressing the "Yes"
buttons (like the ones below) from where you're reading these.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:55
xdemechanik