I would like to make the cell green if the cell is filled in (meaning the gene is present) between all four groups, red if it is only present in one of the groups and then something like yellow if it shared between Group 1 (data in columns O-Y) and 2 (Z-AI), orange if between 1 (O-Y) and 3 (AJ-AM), dark orange if between 2 (Z-AI) and 3 (AJ-AM) and left white if it is shared between any of the groups and group 4 (AN-AQ).
So, I would like to set the conditional formatting based on the cells being filled in or blank. The information below each column is either filled in with a particular unique code if the gene is present or left blank if it is absent, but each code is a mixture of letters and numbers and is unique to each column. I have 29 columns and they each belong to one of four distinct groups. I have an excel document with the results of a genomics experiment (I am looking for which genes are present or absent in certain bacterial groups). I have watched a few youtube tutorials, but I can't seem to find one for exactly what I would like to do so thought I would post on here!