Forum Discussion

valkn's avatar
valkn
Frequent Visitor
8 years ago
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...
  • az2451's avatar
    az2451
    8 years ago

    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

az2451's avatar
az2451
Icon for Resolver I rankResolver I
8 years ago

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's avatar
valkn
Frequent Visitor
8 years ago

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's avatar
    valkn
    Frequent Visitor
    8 years ago

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