I have a dataset for wells and 5 treatment plants (TP1, TP2, TP3, TP4, and TP5), which extends from A1 to F841. The flow path for each well is such that the well flows to TP1, then TP2, and so on. However, sometimes the flow path does not extend all the way to TP5. I have manually entered "None" in the cells corresponding to the non-existent TP2s, TP3s, TP4s, and TP5s. However, I would like to conditionally format or automatically color the last cell in each row that does have a TP PS Code (i.e. 0110010-020, instead of none). I have uploaded 2 pictures. The first picture shows the dataset I have and the second picture shows my desired output (I have manually filled in the cells yellow).
112.7 KB Views: 9
81.3 KB Views: 9