I have this issue with Highlighting of Cells in the Ms Excel worksheet. The range of cells required is, lets say A1 to D10. Cells in this range will be highlighted Red only if it is entered with a lower case text x. If any other text (even a capital X) is entered, that particular cell must be Red. So each cells in that range can remain normal when BLANK and also when entered with lower case x. But if any input is entered other than the lower case x, that cells must turn Red. Can anyone please suggest way out with the Conditional Formatting for this issue.
Tried EXACT(x,A1:D10), with and without quotations and all varuous combinations of FIND, MATCH, SEARCH, etc, but no success.
The conditional format will change the cell reference automatically. You are not required to include the whole range in the formula. That only creates a formula error. Simply EXACT("x",A1) should be fine for string - x.