2 Replies Latest reply on Aug 16, 2018 11:33 PM by Abhaas Mohan

    Conditional formatting in rows (Max,Min) across limited columns

    Abhaas Mohan

      Hi,

       

      I am trying to tackle a feature which is very Excel like (I know, but I am constrained by what's demanded).

       

      I need to conditionally format the highest/lowest value in a row, (but across limited columns, not all, example in the screenshot below - Highest among A-G)

       

       

      I have also attached a packaged workbook.

       

      The headers are in a hierarchy which can expand collapse, so ideally a solution which doesn't kill them would be great!

       

      Thanks for the help in advance!