
Hello,
I would like to set a conditional in column 1 that applies a style if the cell’s value can be found in another range (column 2).
In my example, there’s a match for 1 and 6.
Please upload your file.
I am stupid,
In the image, I used “,” instead of “;”.
PKG answered my question. Thank you to both.
For future reference : COUNTIF(column 2 range ; start of column 1)
