Forum Discussion
Ranking 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...
did you use allselected on the colummn having the values A,B,C,D ... ?
mix rank =
var val = SUM(SMS[Mix Actual])
var final = RANKX(ALLSELECTED(SMS[Particulars]),val,,ASC)
RETURN
final