How manipulate the color property of a table cell

Hi

I am trying to change the colour of table cell if it's value is less than zero.

I know how to use IIF and have it working fine elsewhere.

My challenge is that I want to set the IIF in the color property of one cell of a table.

I can not seem to get to the property window for a cell. I can get to it for a row or a column or a group but not an individual cell. Any one know how I can do this?

The reason I need to do this is that the the column of interest has a group and a detail and I need to set the IIF expression at detail and group level. The detail works fine but the group needs the IIF with SUM and I need to set it at that level.

Thanks

e.g I want:

-60

---

-40

-20

but get:

-60

---

-40

-20

Just select the individual textbox in the table cell and look at the properties window (usually in the right bottom corner of the VS environment). You can set the color expression directly there.

-- Robert