Conditional formatting

[Muthukrishnan V]

Microsoft Excel 2007

Column E contains date in dd-mm-yyyy format.
E5 : 13-01-2020
E6 : 21-05-2020
E7 : 05-02-2020
E8 : 13-10-2019
Today is 29-07-2019. The next upcoming date is 13-10-2019 which is in cell E8;
Is it possible, by a formula, to highlight cell E8 in some way, say by colour?
Thanks,

 

[Fluff]

Select E5:E8 & use this formula
=E5=MIN(IF($E$5:$E$8>TODAY(),$E$5:$E$8))

 

[DanteAmor]

Select range E5:E8
Conditional formatting
New Rule.
In the New Formatting Rule dialog box, click Use a formula to determine which cells to format.
Under Format values where this formula is true, type the formula:

=$E5=SMALL(IF(E5:E8 > TODAY(),E5:E8),1)}

Select Format, select color.
Press Ok.
Press Ok.

 

[Muthukrishnan V]

Thank you Sirs

 

[Fluff]

You're welcome & thanks for the feedback.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[Muthukrishnan V]

Select range E5:E8
Conditional formatting
New Rule.
In the New Formatting Rule dialog box, click Use a formula to determine which cells to format.
Under Format values where this formula is true, type the formula:

=$E5=SMALL(IF(E5:E8 > TODAY(),E5:E8),1)}

Select Format, select color.
Press Ok.
Press Ok.

I do not get result. Msg: Error in formula.
Please help

 

[DanteAmor]

I do not get result. Msg: Error in formula.
Please help

It should be like this, delete the last character "}" :

=$E5=SMALL(IF(E5:E8 > TODAY(),E5:E8),1)