Forum Discussion
Solved
Conditional formatting
I have a table and one of the columns in the table is StatNo which would have a value of 1, 2 or 3. I want the cell to be colored as follows: 1- Green 2- Yellow 3-Red I set up my conditional form...
I sure believe this is possible.
Did you checked whether StatNo column is formatted as number and not as text?
You may also want to change Summarization to Sum.
Regards,
Berat
I switched it to Whole Numbers but I can't do it as Sum because in the case where there were multiple of the same in the Applicaiton field, it produced a sum number in the StatNo field so I have it as Don't Summarize which after adding an additional column produces what I am looking for so Thank You! Another question - is there a way to have it sort so that the highest StatNo is at the top of the list?
To clarify - if possible I would like to have it automatically sort. I know I can click the header and sort it.