Forum Discussion
Solved
Conditional formatting multiple columns in matrix separately
I have a matrix with multiple columns, and I'd like the conditional formatting to apply to each column separately, instead of to the entire matrix. The current result I have formats the background r...
hi, VEG_Admin
Sorry for my careless, you could try this formula for [$/SF/CostCode]
$/SF/CostCode = RANKX(ALLSELECTED('Buildings'[Building Name]),[$/SF],,ASC)Result:
By the way, in the 4th column, these three 0.01 values are different value indeed, please put four decimal places for [
$/SF].
Best Regards,
Lin
hi, VEG_Admin
Sorry for my careless, you could try this formula for [$/SF/CostCode]
$/SF/CostCode = RANKX(ALLSELECTED('Buildings'[Building Name]),[$/SF],,ASC)
Result:
By the way, in the 4th column, these three 0.01 values are different value indeed, please put four decimal places for [
$/SF
].
Best Regards,
Lin
FANTASTIC!!! That worked. I really appreciate you figuring that out for me. Thank you so much for the help.