working on a workspace ; how to change color of value in a spreadsheet by condition

[georges de sousa]

Statistica 13.5

 

My question ,

After running my workspace, i obtain a spreasheet, i want to color the value depending some condition for exemple

if value inV2>V3 then value in V5 will be in red

and if V2

[Jeremy Melville]

Hi,

You can write an SVB function that does something similar to this. This code states that if the value of cell 6 row 5 is greater than cell 7 row 5 then set cell 8 row 5 to an RGB value.

Sub Main

Dim S1 As Spreadsheet

Set S1 = ActiveDataSet

If S1.Range("C6R5:C6R5").Value > S1.Range("C7R5:C7R5").Value Then

S1.Range("C8R5:C8R5").StaFont.Background = RGB(192,255,255)

End If

End With

End Sub

[georges de sousa]

Thank's very much

Kinds Regards

Georges