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

[PrashantSangle]

Hi,

try like

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

Regards

[Peter_Cammaert]

Wow, just discovered Google Translate. Works pretty well

[vireshkolagimat]

Thank you, it's working.

[nilapril2010]

hi,

you can try with this code -

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

Nilanjan

[susovan]

Hi Viresh,

You can also try this example,

if(GetSelectedCount(Dimension)>=1,'<b>')