Forum Discussion

Lior Yosub's avatar
Lior Yosub
Copper Contributor
Apr 26, 2018

Smart Conditional formatting

I hope this is the right place to ask.

I have a table for each exam. In the top row I have the names of the question and in the second row the maximum grade for that question. I want to use a color gradient for the student's result.

Meanwhile, I'm selecting each column and with conditional formatting color each grade.

I want something smarter that will allow me to select the entire table and use a small number of formatting rules to do it.

Charts & Visualizing Data
Need Help

4 Replies

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    May 03, 2018

    Lior-

     

    Is there anyway you could provide a small non-sensitive sample file with a before and after of a small section of your table?  Oftentimes, it can be a lot easier for a community member to resolve your specific inquiry with a small data representation.

     

    Have you looked into conditional formatting color scales? 

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 07, 2018

        Hi Lior,

         

        For max number in your rule you may use the formula like

        =OFFSET($B$3,0,COLUMN()-COLUMN($B$3))

        apply it to any of your columns; and apply formatting by format painter to any other columns you'd like to colour.

        Please see second sheet in attached.

Resources