Advanced filtering and conditional formatting enable users to analyze data in a more organized way. Different filtering options provide users various ways to sort the data. This demo includes date filter, number filter and color filter.

As for conditional formatting, users can easily highlight critical information with certain colors, based on the values in different cells. In this demo, the income column is labeled with different colors to show varying amount for each month.

For details, please refer to Keikai Developer Reference.

<?xml version="1.0" encoding="UTF-8"?>
<spreadsheet id="spreadsheet" width="100%" apply="demo.FocusComposer"
	src="/WEB-INF/books/filters-conditionalFormatting.xlsx"
	maxVisibleRows="17" maxVisibleColumns="7" vflex="1"
	showFormulabar="true" showToolbar="true" showContextMenu="true" />