Projection: the total sales for this week suggested by trend analysis.Īfter populating the data, the application performs the following operations:.Target: the total sales target for this week agreed by the sales team.Last Week’s Total: the grand total for last week.(The pre-defined data can easily be replaced with input from a data source.) The sample data used is: Dataįor the purposes of this application, we’re using pre-defined data for weekly sales. When a target it met, or a projection exceeded, the dashboard shows green. The dashboard compares this week’s performance to last week’s, projections and targets. To give the sales professional an idea of their performance, the spreadsheet has a dashboard as well as the sales numbers for each product.
![conditional formating with spreadsheet converter conditional formating with spreadsheet converter](https://www.gemboxsoftware.com/spreadsheet-java/examples/105/content/ConditionalFormatting.png)
The scenario for this application is a sales team where each individual receives a spreadsheet every week that contains sales by product. One feature that makes it so flexible is that it is independent of Microsoft Office Automation – it does not require Microsoft Excel to be installed on the system in order to work. Aspose.Cells for Java provides a variety of features which are simple to integrate and easy to work with.
CONDITIONAL FORMATING WITH SPREADSHEET CONVERTER HOW TO
This article describes how to use Aspose.Cells for Java to create a simple dashboard in a spreadsheet by applying conditional formatting.Īspose.Cells for Java is a Microsoft Excel spreadsheet API that allows Java developers to create, manipulate and convert Excel files. For example, they can have the text in a cell appear bold only when the value of the cell is greater than 100. Conditional formatting allows users to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell, or the value of a formula.
![conditional formating with spreadsheet converter conditional formating with spreadsheet converter](https://i.ytimg.com/vi/EPNrYyCC_b4/maxresdefault.jpg)
![conditional formating with spreadsheet converter conditional formating with spreadsheet converter](http://wikisupport.mtabsurveyanalysis.com/images/5/56/Cond-formatting_auto-legend_cond-format-spreadsheet.jpg)
One of the features that make Microsoft Excel so attractive is conditional formatting. They are used for everything from creating simple invoices to building complex models.