I am learning excel from scratch, and I have a dataset of around 7000 entries. Some of these entries have texts such as data for cleaning. This obviously is not clean data, and I wish to highlight it. I tried using conditional formatting, but failed. I tried get rid of the special characters altogether, but have been failing to do so as well. Some solutions on the internet suggest using developer mode and writing up a VBA code myself. Is that the only solution? If there is another simpler way to highlight/clean my data, please help.