Categories
- Business Objects (3)
- Best Practices (2)
- Fusion Charts (5)
- Main (3)
- SQL Server (1)
- SSIS (1)
- Uncategorized (1)
- Universe Design (3)
- Web Intelligence (4)
- Xcelsius (7)
- Design Practices (1)
- Excel (1)
- Tips and Tricks (2)
- Workarounds (1)
Archives
- February 2010
- January 2010
- October 2009
- August 2009
- April 2009
- March 2009
- January 2009
- December 2008
- November 2008
- October 2008
Tag Cloud
auto increment
best practices
bonavista
bulletgraph
Business Objects
charting
charting package
conditional formatting
content management
dashboard
datatable
dianne sawyer
dom
Excel
expand
fannie mae
fix
flash charts
fred carter
frederick carter
free
Fusion Charts
grid component
imt slider
inovista
java
javascript
Java Wrapper
microcharts
pathway technologies
populate dimension table
ripoff
scam
sorting
sparkline
SQL Server
SSIS
table
tree grid
universe
User Access
User Management
Web Intelligence
wrapper
Xcelsius
Latest Tweets
-
Guide on Business Objects access levels posted http://davidlai101.com/blog/2010/02/19/understanding-business-objects-access-levels/ - posted on Feb 19, 2010
-
FusionCharts wrapper 1.0 online guide now available - posted on Feb 03, 2010
-
FusionCharts Java Wrapper 1.0 released
Go to http://davidlai101.com/blog/2010/02/02/fusion-charts-java-wrapper-updated/ to check it out! - posted on Feb 02, 2010
-
The future is in sixth sense technology http://www.youtube.com/watch?v=mzKmGTVmqJs&feature=youtube_gdata - posted on Jan 26, 2010
-
Blog has been upgraded to Wordpress. Enjoy! Http://www.davidlai101.com/blog - posted on Jan 24, 2010


Simulating Excel Conditional Formatting in Xcelsius
Conditional formatting in Excel is a feature that is very commonly used and very useful in displaying how well a set of values in a table are doing. Unfortunately we can not transfer the dynamic nature of conditional formatting from Excel to Xcelsius if we were to just insert the table selector object. Basically if the initial binding color of a cell was “Green”, it would stay green even though it were to change to “Red” when the value changes.
Please view my video on how to simply accomplish this using a grid component in Xcelsius
Please visit my post on “MyXcelsius” for a more advanced example of conditional formatting in Xcelsius involving dynamic sliders and charts.
You can download the source file for the example here