How to enable conditional formatting in Statistica spreadsheets?
Article ID: KB0079691
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 10 and later versions |
Description
1. Open a Statistica spreadsheet and select Tools>> Selection Conditions>>Edit
2. Click on Enable Selection Conditions. Let us assume we want to change the background color to Blue when a variable Eye Color (Variable 2) is blue. Write the include cases condition : [variablename]='value'. In this example this will be : "Eye Color"='blue' or v2='blue'. This can also be any valid Statistica spreadsheet function such as contains("Eye Color",'b') would select all variables cases that contained the letter 'b'
3. Click on the Display tab and select the use specified format to identify selected cases in Spreadsheets and then click on Edit Format
4. Choose the format you'd like to edit and then click on Edit... button
5. In this example, since we are changing background, click on Font tab in the dialog that opens up and change the background to blue and click OK twice to close both dialogs.
6. Click on OK to enable selection conditions. Click OK on the warning that the selection condition will be in effect for all statistics and graphs created from the spreadsheet. optionally, you may click on the Don't display this warning again check box.
The Selection conditions will format all cases that match the Selection condition.
NOTE: As of Statistica version 13.5, Statistica does not support multiple conditions via the method described above. However, a simple SVB can be written to format different cells based on conditions. An example of such an SVB script is attached for reference
2. Click on Enable Selection Conditions. Let us assume we want to change the background color to Blue when a variable Eye Color (Variable 2) is blue. Write the include cases condition : [variablename]='value'. In this example this will be : "Eye Color"='blue' or v2='blue'. This can also be any valid Statistica spreadsheet function such as contains("Eye Color",'b') would select all variables cases that contained the letter 'b'
3. Click on the Display tab and select the use specified format to identify selected cases in Spreadsheets and then click on Edit Format
4. Choose the format you'd like to edit and then click on Edit... button
5. In this example, since we are changing background, click on Font tab in the dialog that opens up and change the background to blue and click OK twice to close both dialogs.
6. Click on OK to enable selection conditions. Click OK on the warning that the selection condition will be in effect for all statistics and graphs created from the spreadsheet. optionally, you may click on the Don't display this warning again check box.
The Selection conditions will format all cases that match the Selection condition.
NOTE: As of Statistica version 13.5, Statistica does not support multiple conditions via the method described above. However, a simple SVB can be written to format different cells based on conditions. An example of such an SVB script is attached for reference
Issue/Introduction
How to enable conditional formatting in Statistica spreadsheets?
Attachments
Feedback
Yes
No
Powered by
