sorry for asking, since this is a rather simple question.

I want to conditional format a column based on entries in another column (Example below).

So I want Column A to be highlighted (filled) yellow, if Column B is “X”.

How do I do it? I cannot get the conditional formatting formula to change the range.

‘| Column A | Column B |
‘| Data 1 | |
‘| Data 2 | |
‘| Data 3 | X |
‘| Data 4 | X |

Thanks in advance.

I tried applying the formula to the entire Column B but it didn’t work.