Forum Discussion
NaveenMD
Helper I
2 years agoRanking each cell in column from conditional formatting
What I am trying to achieved is column value based conditional formatting ie. if my value in cell 1 > value in cell 2 then cell 1 should be in darker shade. I believe this can be easily implemen...
Daniel29195
Community Champion
2 years agodid you use allselected on the colummn having the values A,B,C,D ... ?
NaveenMD
Helper I
2 years agomix rank =
var val = SUM(SMS[Mix Actual])
var final = RANKX(ALLSELECTED(SMS[Particulars]),val,,ASC)
RETURN
final