Today's question comes from www.quora.com. This is an interesting question! I like to use Conditional Formatting. People have a hard time reading numbers. You can use color to show trends or make comparisons, say High, Medium, and Low, or highlight specific information. Conditional Formatting

How do I select all of the text in a Cell in Excel?

Conditional Formats

Microsoft Excel calls this Conditional Formatting. The color depends on the condition, which you can choose. Microsoft Excel has a library of Conditional Formatting including Data Bars, Color Sets and Icons. Each of these formats is based on Conditional Formulas, or Rules. Let's start with a simple Rule: show me any amount that is above the average. Let's look at the options.

Try It: Above or Below Average?

Select Column H. In the sample spreadsheet, this is the column with the Amount.
Go to Home ->Styles -> Conditional Formatting.
Go to Top/Bottom Rules.
Select: Above Average.

What Do You See? You will be prompted to select the colors when you select a Top/Bottom Rule.

Try This: Find TEXT Using Find and Replace

Select the entire spreadsheet.

Go to Home ->Editing -> Find and Replace

Select: Go To…

Do This: Click Special.

Select: Constants

Select: Text.

Please note: None of the other options are selected.

When you click OK all of the Text will be highlighted.

These steps can be recorded as a Macro if you wish to create your own keyboard click.

I am a fan of Conditional Formatting. Here is a YouTube that you can watch if you wish. Thanks for stopping by.


Microsoft Excel 2013 Advanced: Tables Work for Me!

eBeth

Elizabeth Nofs, the Computer Mama

New Subscribers Welcome: https://thecomputermama.us

If you would like to stay in touch, please subscribe to my website for:

  • News and Course Announcements
  • Coupons and Freemiums
  • Guides and Mini-courses
  • New subscribers welcome!

Buy the books at Amazon: https://thecomputermama.us/books...

Visit our school at: https://thecomputermama.teachable.com/