Highlight cells that equal

Generic formula 

=A1="X"

Summary 

To highlight cells equal to a specific value, you can use conditional formatting with a custom formula. In the example shown, the formula used to apply conditional formatting to the range C5:C11 is:

=C5=$F$6