With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Thursday, October 12, 2017
yogi_Conditionally Format B4:H6 On Basis Of 'All Visitied' 'Some Visited' 'None Visited'
Conditional Formatting if Cell Contains Range Of Characters I have the following grids
Row1 AB AF
Row2 CH BC
Row3 EF AE
And 2 lists of indicators
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: