How to script color content of column name containing a '>' symbol (or script renaming that name)

marjolein

Dear all,

 

I have a question how to deal with a column name that contains a '>' symbol, such as 'Prob > F' resulting from an Anova.

I want to condition color the cells in this column with a script (as its a repetitive action), however because of the '>' in the column name its not possible. I tried:

1) script color condition the cells: does not work

2) rename 'Prob > F' to a different name without the '>' symbol with a script (to then script color condition the cells): however, renaming also does not work (I have the correct script as it does work for other columns, its really the '>' symbol that causes the problems.

 

I am looking forward to your ideas how to work around this.

 

with kind regards, Marjolein

txnelson

When a column name contains special characters, you need to either use a Column() function, or a :Name() function to be able to handle the name properly

column("Prob > F") << Color Cells( "Red" );
:Name("Prob > F") << Color Cells( "Red" );