yogi_Conditionally Format B4:H6 On Basis Of 'All Visitied' 'Some Visited' 'None Visited'

Google Spreadsheet   Post  #2268

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-12-2017

Question by Wes Plybon

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/pPXu2rd0e-M;context-place=mydiscussions

Conditional Formatting if Cell Contains Range Of Characters
I have the following grids

      ColA  ColB

Row1  AB    AF

Row2  CH    BC

Row3  EF    AE

And 2 lists of indicators

        ColA  ColB

Row 21  A     E

Row 22  B     F

Row 23  C     G

Row 24  D     H

What I want to do is have 3 conditional formatting rules that highlight cells A1:B3 when they 1) contain only values in A21:A24,  2) contain only values in B21:B24, and 3) a mix of values from both columns.

In my example A1, and B2 would fall under rule #1, because both cells have only values from the A source.  A3 would fall under rule #2, because it only has values from the B source.  A2, B1, and B2 would fall under rule #3 because it contains values from both sources.

Here's a link to a sheet with data and expected outcomes:

https://docs.google.com/spreadsheets/d/1lRMdnH32d-rs_8sxiTMLoJLgkN-zdc3FXn0dFWoOVNE/edit?usp=sharing

Any help with this would be awesome.  Thanks!