Forum Discussion
Conditional formatting background color with column containing both text and numeric values
i have a matrix visual which displays info about a employees skills * Java * C# * Customer Service * Punctuality * Technical strength the above are ranked from 1-3 with 1 being bad (red col...
If you wanted to keep the N/A too you could just use another column which has N/A value still in it but still link through the Rank column.
Well this is a new perspective and thanks for giving me an idea this way .
However i have created a new column with the formula
colorvalue = switch("Column name ","n/a",6,"4",4,.......) this created a new col in the table and i have formatted using this newly created column.
Thanks
Jagadeesh