Conditional Formatting in Excel

Today’s question comes from 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!


Elizabeth Nofs, the Computer Mama

Buy the books at Amazon:…

Please evaluate my Courses: Visit our school at UDEMY