7 Replies Latest reply on Oct 19, 2018 9:02 AM by venkatram

    Conditionally Format the Grand Total Only with No Decimals

    Cindy Schmelzer

      I think there has to be a formula that will let me accomplish "conditional formatting" of my numbers compared to the Grand Total number.  I am using the Table Calculation for % of Total.  I format the number to show as a percentage with one decimal pi

       

      I want to show one decimal for each college's % of total but I want the 100.0 to show as 100.  Is there a way to do this?  I'm OK with losing the decimal sign next to the number if that lets me show the 100 in the Grand Total.