Conditional Formatting based on maximum date to another column

[farrukh]

Hi All

I need a condtional formatting based on the maximum date in the column A. If find maxiumun date in column A then change font set to red to column F?


Thanks

[etaf]

try using
=A1=MAX($A$1:$A$12)

where A1 to A12 is your Date range

you put the formula into conditional formatting in F1

for 2007 or 2010 excel version

Conditional Formatting

Highlight applicable range >>


A1:A12


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:


=A1=MAX($A$1:$A$12)


Format… [Number, Font, Border, Fill]
OK >> OK

see attached example - change any date to the maximum and the font should change

if you have more than one date that is the maximum, ie the same date 2 or ,more times - it will also change the font red of all those max dates

[farrukh]

Many thanks perfectly works !

[etaf]

your welcome

if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here