Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formating on calculated data in a pivot table
Hi:
I'm trying to do a conditional format on some e-commerce stats I have calculated in a pivot table. The field types are eBL% eBook% eSI%. I want to say something like if between 0 and .5 collor background red... else color background green... I've been able to do this on data outside of a pivot table but I can't seem to figure out how to do it on a pivot table. Help?? rgds David |
#2
|
|||
|
|||
You can apply conditional formatting to a pivot table, but it's more
difficult, because its size and shape can change. Select a range of cells that you expect the pivot table would fill at it s widest or tallest. Choose FormatConditional Formatting From the first dropdown, choose Formula Is In the formula box, type a formula that refers to the active cell, e.g.: =AND(A5=0,A5<=0.5,A5<"") Click the Format button, and choose the options you want. Click OK, click OK. David wrote: Hi: I'm trying to do a conditional format on some e-commerce stats I have calculated in a pivot table. The field types are eBL% eBook% eSI%. I want to say something like if between 0 and .5 collor background red... else color background green... I've been able to do this on data outside of a pivot table but I can't seem to figure out how to do it on a pivot table. Help?? rgds David -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formating of group of columns and rows | Excel Worksheet Functions | |||
merging and formating data | New Users to Excel | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |