Select all the values in column B. Go to conditional formatting and New Rule.
Format Only Cells That Contain
Set condition to "equal to".
For the range, type in "=$A2". If you select the cell to enter this, be sure to delete the $ between the A and the 2.
Set your formatting. Press OK. Repeat for the other rules accordingly.
|