7 Replies Latest reply on Feb 10, 2019 12:51 PM by Shinichiro Murakami

    how to apply conditional format to each row in a table

    Shenee Salami

      Hi All,

       

      I am hoping someone could tell me how I could apply a 2-colour conditional format to each row based on the kpiid (in the attached workbook). Let's take for example kpiid 15, I want the daily figures that apply to that kpi in the table on Sheet1 going across to be either coloured green or red based on a set threshold. This should apply to the rest of the kpiid's in the table as well.

       

      Can anyone help?