I need a formula to conditional format Cell B2 when something is selected in Cell A2. I am using a Vlookup Formula to pull information in column B when selecting data in Column A. so if data in column A has value on column B, it should stays the same. if data on column A has no value attached on column B then I need the cell B2 to change color.
Column A Column B
<colgroup><col><col></colgroup><tbody>
</tbody>1 ******* $50
2 Bathroom -
3
Thank you
Column A Column B
<colgroup><col><col></colgroup><tbody>
</tbody>
2 Bathroom -
3
Thank you