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



      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!