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?
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.
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.
Elizabeth Nofs, the Computer Mama
New Subscribers Welcome:
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:
Visit our school at: