Having full power over your papers at any time is crucial to ease your day-to-day tasks and boost your efficiency. Accomplish any goal with DocHub features for document management and convenient PDF editing. Gain access, modify and save and incorporate your workflows with other protected cloud storage.
DocHub gives you lossless editing, the chance to use any formatting, and securely eSign papers without searching for a third-party eSignature software. Obtain the most of your file management solutions in one place. Try out all DocHub features today with your free of charge profile.
[Music] hey hows it going guys in this excel tutorial ill be covering how to use conditional formatting to highlight cells containing text that you want to query sometimes instead of high end or high rows or columns based on criteria we simply just want to get an overall picture of which item met the criteria so here let me give you a quick demo on what be doing in in this exercise all right so this excel spreadsheet is the final product in cell a3 i have an input field so here let me remove that and below the average table that contains a list of states now lets say i want to search for any states contain letter c so if i type c its going to highlight every single state containing the letter c now i can also type a word lets say kelly so c-a-l-i and based on this uh text query only in california met the criteria now if i type a-l now i get three states so alabama alaska and california and this is the feature that were going to implementing in this exercise right so if you have