Condtional Formatting Help!

[sultan]

Hi guys,

Need some help.

I need to have the following result from the result in 2 seperate cells, both of which are using data validation dependent lists. (user selects the options from the two lists, if they reach an illegal combination bob=tom/tom=bob then I want the adjacent cell to turn red.

If cell H5="bob" and I5="tom" cell J5 turns red.
If cell H5="tom" and I5="bob cell J5 turns red

I would like this to be in ONE conditional format, as the other two conditional formats are occupied.

Thank you guys


Sultan

 

[Joe4]

This is the Conditional Formatting formula you require:

=or(and(h5="bob",i5="tom"),and(h5="tom",i5="bob"))