Highlight oldest date in excel worksheet

[liamm]

Hi, I have an excel worksheet that I use to list stock. The sheet is laid out to mimic the shape of my stock room i.e. the data is not just listed in rows. I have multiple blocks of cells which include date for product name, amount, delivery date. What I would like is to be able to highlight a block of cells (or cell) according to which date is the oldest.
I have no idea where to start on this so would pappreciate anyones help.
Thanks
Liam

If you can help, GREAT
If I can help, EVEN BETTER

 

[SkipVought]

Hi,

Data > Conditional Formatting
[tt]
Formula Is: =CellRef=MIN(DateRangeRef)
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[liamm]

Sorry SkipVought, could you give me some more help on how to use this please?

If you can help, GREAT
If I can help, EVEN BETTER

 

[xlhelp]

Hi, liamm

Skip's formula will highlight only one cell.

If you want to highlight more than one cell, then use
=CellRef<SMALL(cellrange,k)

I don't know if there is a different way but, what I do is go to the first cell in the range; go to Format, Conditional Formatting; change the condition to Formula is and then type in the formula. So, for example, if your range of cells is A1:A25, then with A1 being the Active cell you would enter
[red]=A1=MIN($A$1:$A$25)[/red]
or
[red]=A1<Small($A$1:$A$25,6)[/red] where you want five lowest values. Set your format. Click OK. Then, use format painter to apply the conditioning to the rest of the cells.

A man has only two choices: He can be right or he can be happy.