Forum Discussion

pborah's avatar
pborah
Solution Sage
2 years ago
Solved

Matrix table conditional formatting for a value field across two columns

I have this matrix table that shows the clock-in time of two employees -

 

 

Rows are dates and columns are the two employees. Values are the earliest times our systems detect their key-card swipes every day at the entrance door.

 

I want to use conditional formatting to highlight in red and green whichever one came in later than the other. So if employee A was late compared to employee B, A gets highlighted in Red and B gets highlighted in Green. Is there a way to do this?

 

Also if there is a way I can plot this in a line chart comparing the clock in times of the two employees over two different lines, that would be even better but so far I haven't been able to figure that one out either.

 

Thank you.

1 Reply