How to do conditional formatting based on another cell?
Answers
Answered by
2
=>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.
Similar questions