How do you write an expression for a style rule that will check if the value from column A exists in columns B, C, D & E?
I have a polygon layer that I would like to flag with a style depending on whether the values from column 'MH#' are found in any of the 'MH1-MH4' columns.
record 39: MH# 883031 is found in the MH2 column of record 38, I'll make it red. record 42: MH# 883777 is found in the MH1 column of record 37, I'll make it red. record 37: MH# 882516 is not found in any of the MH1-MH4 columns, I'll make it yellow.