Conditional formatting in Pivot

[Nagesh Volety]

Hi Chandoo,


First of all thanks for this Portal & Forum,


Day by Day there are new innovations with old formulas, which is in-exhaustive,


Thanks for all the fellow-researchers & contributors,


I have a strange question,


Can we have a conditional formatting in Pivot ?


for example -


if the activity is Completed, Work in Progress, Yet to Start to be highlighted for the customers on the left hand of the pivot

 

[Dee]

Hi Nagesh,

Conditional format to pivot is same as that of conditional format you do for any table or cell.Give a try it should come else..we are here to help...


Dee...

 

[brijendraydv]

Hi Dee,


same quest here i used it as GETPIVOTDATA("Savings",$A$14,"Beneficiary Sub Profit Center Name","Automotive Asia Pacific","Year",2013,"Groups","Assembly")>'500000' put not coloring anything.let us know


Thanks,