advanced conditional color formatting

I have 2 columns and 7 rows with the following letters, one on each row column 1 has a,a,a,b,b,c,d and column 2 y,x,z,y,z,x,w

Basicaly what we need to do is confirm that al the values “intersect”. the color formating that we manually do is the following:

color in green all of the “a” values (or the value that has the highest frequency), then we color in green all of the values in column 2 that are next to an “a” value in column 1 (ay,ax,az) on rows 1,2 and 3 . Then (we sort a-z column 2 due to large number of rows) color any value that has at least 1 in green, in the example we would color all “y”s, “x”s and “z”s. Now we go back to column 1 and color any values that have a value on its respective row painted in green. the we paint all “b” and so on… in this example row d,w would not have been colored in green as it does not relate in any way. I know that the conditional formating is probably not the way to go on this analisis but I haven´t been able to find any other way. any suggestion would be of great use.

Thank you for beeing the heroes in the dark!

By: Eric

Leave a Reply

Your email address will not be published. Required fields are marked *