In this article, you will learn how to use Advanced Conditional Formatting to search text in data. Here we have taken the example for employee Performance rating data. We two type of search –Search Text from Specific  column and Search in all columns. Note: This trick is useful only for small data set. Search Text … Continue reading Search Text from Specific or all columns in Excel