Microsoft Excel 
ITTraining@sgul.ac.uk Page 33 St. George’s Information Services 
QUICK FORMATTING 
 
 
 
 
 
 
 
 
 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
Try This Yourself: 
Open 
File Before starting this 
exercise you MUST open 
the file E1355 Quick 
Analysis_1.xlsx… 
 
Click in cell B5, hold 
down , then click in 
cell E9 to select the range 
B5:E9 
 
Point to the bottom of the 
selected range so that the 
Quick Analysis button 
appears, as shown, then 
click on it to see the 
Quick Analysis gallery 
 
On the FORMATTING 
tab, point to Data Bars to 
see data bars 
representing the size of 
the selected values 
 
Point to Colour Scale to 
see colours used to 
signify the scale of values 
(from red for low to green 
for high) 
 
Point to Top 10% to see 
the top 10% of values 
 
Click on Greater Than to 
see the Greater Than 
dialog box 
 
Type 200000 in Format 
cells that are GREATER 
THAN, then click in cell 
A1 to see the changes 
 
The first tab in the Quick Analysis gallery is 
FORMATTING. This tab provides access to the 
conditional formatting tools of Excel. These are 
the tools that allow you to analyse data by 
colouring it or presenting it in a slightly different 
way. In the Quick Analysis gallery you can apply 
data bars, colour high and low values, values over 
or below a value, and more. 
2 
3 
6 
For Your Reference… 
To apply Quick Formatting in a worksheet: 
1. Select the range to be formatted, then click 
on the Quick Analysis button 
2. Choose the desired formatting from the 
FORMATTING tab 
Handy to Know… 
 Quick Formatting applies conditional 
formatting, not the standard formatting. 
 The Clear Format option in the Quick 
Analysis gallery will clear any conditional 
formatting that has been applied.