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 (12)
- Design Practices (3)
- Excel (2)
- Tips and Tricks (4)
- Workarounds (1)
Archives
- July 2010
- May 2010
- April 2010
- March 2010
- 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
SSIS
table
tree grid
universe
User Access
User Management
Web Intelligence
wrapper
Xcelsius
Xcelsius 2008
Latest Tweets
-
Using Filtered rows instead of VLOOKUPS in Xcelsius @
http://davidlai101.com/blog/2010/07/02/using-filtered-rows-instead-of-vlookup/ - posted on Jul 03, 2010
-
New Post on the Xcelsius Push Button Object @
http://davidlai101.com/blog/2010/05/29/xcelsius-push-button/ - posted on May 29, 2010
-
Xcelsius dynamic color binding article and video posted @ http://davidlai101.com/blog/2010/04/06/xcelsius-dynamic-color-binding/ - posted on Apr 06, 2010
-
New post on Xcelsius Canvas Containers @ http://davidlai101.com/blog/2010/03/26/xcelsius-canvas-container/ - posted on Mar 26, 2010
-
Guide on Business Objects access levels posted http://davidlai101.com/blog/2010/02/19/understanding-business-objects-access-levels/ - posted on Feb 19, 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