6-way conditional formatting

awmiller

New Member
Joined
Jun 4, 2008
Messages
8
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!!
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
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..
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
Code:
=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"))))
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,956
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top