I have a worksheet that is using conditional formatting to show duplicate values within certain ranges. Some of these ranges will contain phone extensions that use * as one of the digits. This is causing problems with trying to use countif. Is there any way to tell excel to use the exact value within the cell as opposed to interpreting that * as a wildcard?
Bookmarks