Forum Discussion
Conditional Formatting background cells in Matrix based on multiple column conditions
Hi jrmemelink ,
Pls refer the below link, and check if it is helpful ,if question still not solved ,pls share a sample data and expected output result.
Best Regards
Lucien
- jrmemelink3 years agoFrequent Visitor
Hi v-luwang-msft,
This is not it unfortunately.
I added the desired outcome in my post. Im not familiar with uploading data through this community, so i created a link through wetransfer: https://we.tl/t-k7w5WOx08e
(Important to note is that column numbers 1-7 are given by another data table which is connected to the data through Column MD_LastStickingDay
I think the way how to do this is by creating a measure for each Column if it is lower than or equal to MD_LastStickingDay, but have not figured out how to do so. Next step (i think) would be to do conditional formatting based on that measure.Any help is welcome!