Forum Discussion

ninakarsa's avatar
ninakarsa
Helper II
6 years ago
Solved

conditional formating on matrix

Hi All,@ members   I am trying to to use conditional formating on a matrix to highlight the % in the matrix which are between 5% and 100%, but this gives me the following which higlights all cells ...
Show and Tell
  • Gordonlilj's avatar
    Gordonlilj
    6 years ago

    Hi,

     

    Try changing from percent to number and 5 to 0.05 like below and see what result you get

     

     

Gordonlilj's avatar
Gordonlilj
Solution Sage
6 years ago

Hi,

 

Try changing from percent to number and 5 to 0.05 like below and see what result you get

 

 

  • ninakarsa's avatar
    ninakarsa
    Helper II
    6 years ago

    Gordonlilj  this works great. thanks so much