Hi,

I have applied this formula =AND($C6="Other",$E6=1) for conditional formatting. c6 & E6 are part of a Pivot Table. The Conditional formatting formula is applied in a table outside the pivot. But this doesnt seem to be working. Appreciate any help.

Thanks & regards