Thursday, October 12, 2017

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!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:

Any help with this would be awesome.  Thanks!