conditional Formatting with colors

[slacknoise]

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,

[Debraj Roy]

Use the same logic.. what you have applied in Conditional Format..
If is not "Conditional Format > Using Formula" then, Please upload sample file..

[slacknoise]

example.xlsx


here is an example. Any help, ideas of how to do that?

[slacknoise]

nobody could help me on this one?