Maximizing Connectivity & Productivity

Conditional formatting in Excel

Use this feature to highlight different aspects of data and make it more readable.

Select the data containing the info to be highlighted.  Go to Home->Styles->Conditional Formatting->Highlight Cells Rules and then select which rule applies best.

If you are adventurous, you can also create your own rules.  Go to Home->Styles->Conditional Formatting->New Rule.  Select a Rule Type.  The Rule Description section below will change according to the Rule Type selected.  

The Rule Types allow you to format cells based on their values, cells that contain.., top or bottom ranked values, values above or below average, unique or duplicate values, or by formula.

Conditional formatting data bars can be used sometimes instead of a chart. Go to Home->Styles->Conditional Formatting->Data Bars

Or you can shade alternate rows. Selecte all cells, then go to Home->Styles->Conditional Formatting->New Rule.  Select the ‘Use a formula to determine..’.  In the ‘..formula is true’ box, enter the following


or for checkerboard shading –


Press the Format button,  select the fill tab and the fill, and click OK.

Edit the rule(s) using Manage Rules.

Leave a Reply

You must be logged in to post a comment.

Mississauga, ON, Canada 905.607.3500