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

For your CF formula, use an AND() formula, something like:

=AND(A1="Insulin Dependent",TODAY()-B130)


--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"yateswdy" wrote:

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

On Tue, 20 Oct 2009 07:06:01 -0700, yateswdy
wrote:

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

I made a drop down bow for my football tracking workbook on Microsoft's
User submitted section. In the second sheet, one picks which week from
the big drop down at the top of the page, and the entire week's football
stats (looked up from other sheets) pop into the current sheet.

The first one had some errors, and my new one has many of the first 6
weeks already filled in and has been fixed, but MS has not put everyones'
submissions for THE LAST TWO WEEKS up YET.

They say about 48 hours, but they cannot even dedicate enough of
someone's time to manage the templates department correctly. DANGIT!

TWO WEEKS are coming up, not two days! The dude must have been on
vacation. They'll have it up soon. Maybe my rant will light a fire
under their hineys.