Excel 2007 : Change the content of a cell

**brantrumpel** · 02-17-2012, 05:01 PM

Hello,

I work for a construction company and I am making this spreadsheet to keep track of work. I have a job status column with a drop down list. I was the job status to change automatically to complete once we input a date in a different column. I made a simplified example below;

I have a drop down list in cell A1. The options in the drop down are "Ready", "Active" or "Complete". I need help finding a way to make the value in cell A1 become the text "Complete" if there is any value in cell B1.

Can anyone help me with this?

**FDibbins** · 02-17-2012, 07:45 PM

In the dropdown cell add this formula...

=if(isblank(your_date_cell,what_ever_you_it_to_show,"Complete")

If that doesnt work, maybe upload a sample to work on?

**sushil10s** · 02-20-2012, 11:03 AM

Excel does not allow any formula to yield result for value(s) in the cell where you are applying the formula.

You may use another cell (may be C1) instead.

=If(Isblank(A1),"","Complete")