I want the contents of of a cell to change based on what is selected in a
drop down list. Example Drop down list has the option of selecting Insulin
dependent or non insulin dependent. If insulin depedent is chosen the i want
a cell to highlight green when 30 days have past. I know how to highlight
based on todays date. But I can not figure how to change the contents of the
cell based was is chose on the drop down box.

Thank you