Create Search Text without using VBA in MS Excel

Create Search Text without using VBA in MS Excel

1-Using Conditional Formating
2-Use a Formula to determine which cells to format
3-Type a formula  =AND(ISNUMBER(SEARCH($C$6,B11)),$C$6<>"")
 on the cell when you type words to search in the column contain search text
Example : C6 is the cell for you  to  type word which you search in column B11

Posted in: Computer Skill