Conditional Formatting Based on Selected Drop-Down

[mayzelleh]

I'm looking to enhance my conditional formatting to highlight the cell in column C if the content is not an option from the drop-down fields specific to another cell. My spreadsheet has two columns with different drop-down fields. Column B is the subject and column C is the Type, below is an example of the lists setup. Column C drop-down is based on what's entered into column B.

Right now I have the following format values. However, as long as the text is listed in the types formatting is not affected. I'd like it to change if the content does not match the list specifically to the subject options.

=AND(NOT(ISBLANK(B8)),ISERROR(MATCH(B8,projectID,0)))
=AND(NOT(ISBLANK(C8)),ISERROR(MATCH(C8,taskID,0)))

Subject Column B	Type Column C
Audit	Deposits
Audit	Other
Meeting	Other
Training	Deposits
Training	Leadership

<tbody>
</tbody>

 

[makiwara]

Can you give more information? Highlight what you need and make an example drop down field please.

 

[mayzelleh]

Is there a way to up load my spreadsheet?

 

[mayzelleh]

There are a number of team members that use the same template that is eventually combined to analyze where everyone is spending their time working. The idea is to try and have all users use similar terminology so analyzing the data is much easier. The subject (column B) line requires that one of the drop downs be selected where as the type (column C) will allow the user to type something other than what's available in the drop-down. There may be duplicate Types as the list is based on the subject.

For instance, if the following was in the spreadsheet Trust would be highlighted since it's not an option in the drop-down for the Audit subject and Other would be highlighted next to Training as that's not in the Training drop-down.

Column B	Column C
Subject	Type
Audit	Other
Audit	Trust
Meeting	Other
Training	Other

<tbody>
</tbody>

If there's a way to upload my template, just guide me through the process and you can look at the actual spreadsheet.