Font colour in cell table

[HerveM1234]

Hi,

Is it possible to modify the font colour in a cell table depending of the value to display ?
For example, values calculated above 100 in red and below 100 in green.
Thanks for your help.

[HerveM1234]

Hi,

Is it possible to modify the font colour in a cell table depending of the value to display ?
For example, values calculated above 100 in red and below 100 in green.
Thanks for your help.

[Bernhard Kantz]

The only way to modify the font color of a cell table is to use VBA (in FlexPro Professional). You can check if the value is out of limit and then change the color. Here is an example how to change the font properties of cell nr 3:

Dim myTable As CellTable
Set myTable = ActiveDatabase.ActiveFolder.Object("CellTable", fpObjectTypeCellTable)
Dim myCell As CellTableCell
Set myCell = myTable.Cells(3)
With myCell.Text.Font
	.Italic = False
	.Name = "Arial"
	.Size = 12
	.Color = &H8000000F
End With

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[HerveM1234]

Hi,

Thanks for your reply.
The font setting works very well

The problem I have is the value : myCell.Text gives something like :%{myfpscript_expression}
How in VBA can I compare this “value” to an integer or an string for example ?

Thanks again

[Author]

Posts