Thanks again to Srinivas Dandamudi for posting the previous example on Simulating Conditional Formatting! 
It works great as a brute force method, however we would need to have a total of 3 objects per cell (100 cells = 300 objects). In addition, we would have to replicate the the behaviour of each cell and carefully place them which would take a long time even for 10 cells.
Instead of using a seperate rectangle for each cell, we can use a grid and enable alerts on the grid. To simulate the table selector, you can just overlay a spreadsheet table object on top of the grid. The key here is to choose an empty display area for the table so that we don’t have overlapping text.
Here are the steps to accomplish the trick
Step 1:
Insert a grid object.
Step 2:
Setup the grid alerts based on the value of each cell.
Step 3:
Overlay the spreadsheet on top of the grid if you want to be able to select the rows like the example on part 1.
Make sure that the display data is pointing to cells that are empty so that we dont have overlapping text
The source code can be found here [download id="2"]
Note that I’ve used Srinivas’ previous source code and removed a bunch of stuff both in the Excel and Xcelsius file to make things simpler to understand.
Simulated Conditional Formatting part 2 http://bit.ly/IuTHR
[...] visit my post on “MyXcelsius” for a more advanced example of conditional formatting in Xcelsius involving dynamic sliders and [...]
Hi David,
you approach has the benefit of needing much fewer components – for the price that the formatting of the cell contents is more limited and that the columns and rows cannot have varying sizes.
So, before seeing your approach, I have left a reply to Simulated Conditional Formatting that briefly explains two other approaches that keep the flexibility of Srinivas’ approach with fewer Xcelsius components and fewer formulas.
Kind regards,
Kai
This is an enxlleect answer to this problem, thank you for taking the time to post such clear instructions!!