Conditional formatting

[valkn]

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?

[az2451 · Accepted solution]

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

[valkn]

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?

[valkn]

To clarify - if possible I would like to have it automatically sort. I know I can click the header and sort it.