6-way conditional formatting

[awmiller]

First off... thanks so much for looking into this issue!! Here's my problem....

I have a spreadsheet wherein I have a contact name in column b, one status type in column c, another status type in column d, and I want an action in column e to be automatically populated based upon the values of the contents in columns c and d.

Here's the possible status and their associated action item:

(Col C | Col D | Col E)

Yes | Yes | No further follow-up required
Unknown | Yes | Contact to confirm
Unknown | Unknown | Still need to track down
Unknown | No | Contact for updates
No | No | No further follow-up required
No | Yes | No further follow-up required


So how would I go about setting this up? Thanks so much for all your inputs!!! I really appreciated it!!

 

[LilStevie]

AW,

Would you prefer to do this with a formula or with some VBA scripting?

Either way is workable. If you plan to share this file with other users or on a network then you may want to consider using formula otherwise I would stick with the VBA method..

 

[awmiller]

I'd like to do this in a formula if at all possible. Thanks so much!

 

[Scott Huish]

With those possibilities for the cells, it seems like there may be 3 possibilities missing:

Yes and No
Yes and Unknown
No and Unknown

What do you want to do with these?

BTW, this is not Conditional Formatting.

 

[awmiller]

Excellent catch!! But the only other one I need is shown below.

Yes | No | Contact for updates


And thanks for clearing up that this is not conditional formatting!! Maybe that's what's throwing me off.

 

[Gerald Higgins]

=if(c1="NO","No further follow up required",if(d1="NO","Contact for updates",
if(c1="YES","No further follow up required",if(d1="YES","Contact to confirm",
"Still need to track down"))))

 

[awmiller]

Thanks so much!! I'll go give that a try!!