Question

How to do conditional formatting based on another cell?

Answer 1

=>Select cell B3 and click the Conditional Formatting button in the ribbon and choose "New Rule".

=>Select "Use a formula to determine which cells to format"

=>Enter the formula: =IF(B2="X",IF(B3="Y", TRUE, FALSE),FALSE) , and choose to fill green when this is true.