trying to combine two formulas in one cell

Good evening,

I am hoping somebody can help me out. I am rockie on excel....I am working a couple of days in this, I am almost 90% done. At this point, column "K" will change to a red, orange, or green flag (base on date 30, 60 and 90). Column "L" will showed "Done" if Column "J" has a date. I will like to combine column K and L in one. In this way, if the column "J" has a date will delete the flag and show only done. I attached my excel sheet.

Thanks for any support

Originally Posted by 6StringJazzer

Here are the steps to do this. I've done it in your file, though I left the last column intact.

First, you have to update your formula to show Done when the conditions are met. So the formula in L becomes:

Formula:

=IF(J3<>"","Done",TODAY()-H3)

We keep the flag formatting, and add another rule to make it green when Done. See the CF rules for that.

To allow "Done" to be visible, we have to turn off the checkbox in the icon rule that says Show Icon Only. When the box is checked, the cell value is not displayed.

One last step. Now, if the cell is not "Done", it will show the number of days calculated by the formula. To suppress that we use custom formatting:

;;;@

This format means that if the value is a number, do not show anything, but if it is text, show the text.

Jeff,

Thank you! It works perfectly for me!

V/r

Fred

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the addreputationicon.jpg icon below their name.

Also, no need to Quote a post to reply to it. You can just hit Reply.