Friday, March 16, 2018

yogi_Apply conditional formatting based on string appearing twice inside a cell

Google Spreadsheet   Post  #2398

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-16-2018

question by: Paul Katzman
https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!topic/docs/KaUHdrshU2Q;context-place=mydiscussions
Apply conditional formatting based on string appearing twice inside a cell
Hi, I have a table of tests run on a batch of files. Y axis are the specific files, and X axis are the tests. Each test is able to be interpreted in two different ways, and rather than double my number of columns I have the results in a cell on multiple lines inside the cell. See below for crappy ASCII diagram.


                        Test 
File 1            Result A
                      Result B

File 2            Result A
                      Result B

File 3            Result A
                      Result B


What I'm trying to do is to only highlight cells that contain the same string value for both Result A and Result B, I don't care about tests where Result A and Result B are different values. How is this possible?

Thanks for the help folks.