Hi,
I'm trying to make a combo box grey itself out if a date in another combo box is between two particular months of the year. So for instance if the date chosen in the drop down menu of Combobox1 is between March 1st and June 30th, then I want Combobox2 to grey itself out. I've tried this using conditional formatting and for some reason can't get it to work.
This is the expression I first tried to use in a conditional formatting rule for Combobox2:
([combobox1].value>3/1/14) and ([combobox1].value<6/30/2014)
For some reason this doesn't seem to be working the way I want it to. When I pick a date that should grey out Combobox2 it doesn't grey it out. I've also tried the rule below and it doesn't seem to work either:
([Combo262] Between 3/1/2014 And 6/30/2014)
I'm at my wits end. Any help would be greatly appreciated.
Thank you!