Conditional formatting of cell borders in straight/Pivot table

[miranrai]

Hi,

I have a straight table (Image attached). I want to have conditional cell borders. As want to show certain values only once for specific dimension values. I have tried using Custom Format Cell but somehow it's not working as per condition given. Please help.

[Anil_Babu_Samineni]

I don't think whether we have control of this? You may change it to BG color and cell border with same color when Condition is Zero like If condition. FYI Attached

[miranrai]

Thank you for your reply Anil. I think Custom Format Cell is should work that way as there's conditional expression. But it's not working. I wanted to show price 100 as 1 value for

Cycles

Gears

Helmate

Gloves

than 4 values & no border as shown in image attached so 100 would appear as a single value for products above.

This is specifically for export to excel.

[Anil_Babu_Samineni]

Like This?