Dear community,

I have two columns. One column contains text and some cells are highlighted in yellow. In the second column i would like to have binary values 0/1 conditioned of whether the cell on the left is highlighted in yellow or not. So for example a cell in column A is highlighted yellow i would like to have in the same row in column B the value of 1. How do i do that? any help highly appreciated. Thanks in advance.

best regards,