Forum Discussion
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 formatting as follows:
But it results in the following:
Is it possible to get the results I am looking for?
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
3 Replies
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.
