How to conditionally set  background colour of table cell?

How to conditionally set  background colour of table cell?

  
How to conditionally set background colour of table cell? Any ideas ?
Dear Orlando,

For conditional formats we suggest the use of Extended Properties. In the case in hand, you would leave the Cell’s native “Style” property to “(none)” (as this kind of formatting is always unconditional), open the Extended Properties’ dialog for your required Cell and add a property style with a value similar to

FormatBoolean( boolean-expression, "background-color: #00ff00", "" )

In this particular case, if boolean-expression is true, the Cell’s background will be green, while if if boolean-expression is false, the background will be left unchanged (i.e. it will use the page or the table’s background colour).

Hope this helps.

Best regards,


Miguel