Cell format problem

[shrimpy]

Hi All,

In excel, i can apply formula [Red] #,##0 for number,
then the number will have format and color.

can we apply this format onto text and data value as well?

Thanks

[John Bowlin Bosco K]

Hi Shrimpy,

Thank you very much for your interest in Syncfusion Products.

To format the cell value, conditional formatting can be used by which the contents of a cell are dynamically formatted, based on a value. To illustrate this, we have created a sample in which the cell value containing "0" is formatted with font color as red and the sample has been attached below. Could you please try the sample and let us know if this helps you.

Sample Link:
http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=ConditionalFormatSample1013321074.zip

Also, please navigate to the attached documentation link to know more about the conditional formatting.

http://help.syncfusion.com/ug_91/Reporting/XlsIO/Windows%20Forms/default.htm?turl=Documents%2Fconditionalformatting.htm

Please let us know if you need any further assistance.

Regards,
Pauline Bosco

[shrimpy]

Hi John ,

Great thanks for you reply.

It is not what i want. but still help.
but basicly the numberformat can apply to any type of values
this is what i tried it out.


still thank you for your help.

[Sridhar]

Hi Shrimpy,

Thank you very much for the update.

In Essential XlsIO we are supporting all the numberformats to the spcified type values as same as in MSExcel.

Please go through the following online documentation link for more deatails on Number Formatting.

http://help.syncfusion.com/ug_92/Reporting/XlsIO/Windows%20Forms/default.htm?turl=Documents%2Fnumberformatting.htm

Could you please let us know your actual requirement in applying the number formats so that we can able to sory out easily. Please update the sample for the same if you have any concerns.

Please let us know if you have any futher clarifications.

Thanks,
Sridhar.S