However, for more flexibility, you could use your own formula, as explained in this article.
Case sensitive option
By default a comparison is not case-sensitive.
Highlight cells that equal
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 If the value in F6 is changed, the highlighting will update automatically.
