Apply a style if the value of a cell appears in another range

conditional_cell_equal_range
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.

Unbenannt 1.ods (40,1 KB)

1 Like

Hello,
Thank you for trying but it doesn’t work for me, nothing happens.

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)