Conditional formatting custom

[sangeeta25]

Hi all,

I have column G which has a drop down list and has the following options: "June 2015" or "Septermber 2015" or "December 2015" what i would like is to create a conditional formatting custom rule so that whenever a use selectes THE MOST RECENT date option from the drop down, then this will turn yellow, so, in this case whenever someone selects "December 2015" then the cell will turn yellow, so when someone adds for instance "Febuary 2016" to the drop down list then when this date is selected, as it will now be the most recent or most latest date, then this will go yellow.

Can anyone assist in obtaining a custom rule/formula for this?

 

[oldbrewer]

somewhere you have a column that is your drop down list and let us say it is in A1:A3

in B1 =if (A1=max(A1:A3),"max","")

say you drop down selection is cell D1

the cond format formula in D1 is =vlookup(D1,mytable,2)="max"

mytable is defined as A1:B3

 

[sangeeta25]

Is there not just a formula to use in the custom bit when selecting conditional formatting?

 

[oldbrewer]

not sure what you are asking - I have given you a formula to apply to your drop down cell..........