ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you set conditional formatting in pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/209969-can-you-set-conditional-formatting-pivot-table.html)

gary.waterworth

Can you set conditional formatting in pivot table?
 
I want to set conditional formating in a pivot table can you suggest is this
possible?

DILipandey

Can you set conditional formatting in pivot table?
 
Hi Gary, Yes you can set conditional formatting in pivot table. It is same
as setting conditional formatting in any other excel worksheet, the only
difference is that if you need relative reference, you need to type in the
reference by typing them in the conditional formatting logic. thanks
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"gary.waterworth" wrote:

I want to set conditional formating in a pivot table can you suggest is this
possible?


Dave Peterson

Can you set conditional formatting in pivot table?
 
But if you pivot the table, you may not want those same CF rules.

gary.waterworth wrote:

I want to set conditional formating in a pivot table can you suggest is this
possible?


--

Dave Peterson


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com