conditional formatting

[vireshkolagimat]

Hi Guys,

I have below sample data and i need to make certain rows bold based on the row dimension description.

Dimension	Sales1	Sales2
laptop	2	7
Printer	6	4
Desktop	2	3
Total	10	14

If dimension is Printer, then i need that Printer row should be highlighted in bold. and also the total row should be in bold.

Kindly let me know if we can achieve this.

Regards,

Viresh

[MK_QSL]

Go to Dimension Tab

Click on + Sign of Dimension

Text Format

Write below

IF(Dimension= 'Printer','<b>')

[sunny_talwar]

Isn't the Total row already bold? I thought I remember seeing it bold

[Kushal_Chawda]

Go to Dimension Tab

Click on + Sign of Dimension

In Text Format put below expression

IF(Dimension= 'Printer','<b>')

Sames expression you need to write in both sales1 and sales2 expression Text format

[sunny_talwar]

Seems like it

Straight table

Pivot table

[sunny_talwar]

Oye Manish ka copy paste karta hai

[Kushal_Chawda]

Ha to itna type karte kon bethega.. or extra bhi dala he na.

[sunny_talwar]

yeh hua na honest chor

[Kushal_Chawda]

Imandari hi to humari pehchan he

[vireshkolagimat]

Hey, thanks it is working. How to compare the multiple line items in the same expression.

I tried the below expression but not getting the result as expected.

IF(Dimension= Match(Dimension,'Printers','laptop'),'<b>')

let me know if this can be possible.

Regards,

viresh