Conditional Formating in Pivot Table Report in Excel 2010

Conditional Formating in Pivot Table Report in Excel 2010

While working with pivot table Report many times you have to apply conditional formatting to table,column or cell

for eg like if table or column has negative value make that color backround red.
if greater than 1000 then black
if equal to 500 then red and so on...

So in this post i will show how to apply conditional formatting in pivot table report in excel 2010.

Note: we will use the same pivot table which we have created in previous post

Creating Excel Pivot Table using SQL Database

http://sqlandssrssolutions.blogspot.in/2013/12/creating-excel-pivot-table-using-sql.html

so we will apply conditional formating in Salary Column like

if salary is equal to 10,000 then Darkyellow color text with light yellow background
if salary 9000 then redcolor text with light red background
if salary less then 9000 then greenbackground with bold text

For this select empsalary column

Go to home tab

conditional formatting

Higlight cells Rules

-Here you will find lots of options

-Greater then
--less then
--between
select the condition Equal to 
write  10,000 in first cell and in second cell some default custom is there apply 
Light red fill with Dark red background

 then apply other conditions.

Screenshot after applying condition format and options of condition format.

apply condition as mentioned above....

In condition format you can apply other conditions option like 

 Top Bottom Rules--for applying condition in top 10 or bottom 20 like this.
 Data bars- To convert your column to Bars.
 color scales - To apply coloring in cell and columns.
Icon set- In order to use indicators.