I have got a matrix which shows the Team member in row and months in column. the data shows the amount of work (in terms of days) allocated to team member. Is it possible to conditional format those cells where the team member has more work than the amount of working days in a month. Every month has a different number of working days
My matrix visual is below. for e.g. Person F has 21.25 days of work in Sept 20 while there are only 21 working days in sept20. Can Sept 20 column be highlighted for Person F by conditional fomratting or DAx measure ?