Setting an alert for individual cells

I have one column of data coming back from a web service.

There is 10 rows in this column.

I want to display the data in a simple grid, or spreadsheet view.

How can I set it up in Xcelsius so that I can have individual coloured alerts for each cell?

- each cell can have different thresholds.

- each cell can be red, green or yellow depending on its own threshold.

So for the first row, I might want it so that if the value is 30, then this is green, but on the second row, a value of 30 could mean red.

Does this make sense?

I did find something about conditional formatting, but it involved charts and I just want to do it on a spreadhsheet...

Edited by: sterankin on Feb 18, 2011 6:12 PM