Forum Discussion
Solved
Conditional Colour Formatting using 2 different columns in the condition
Hi All, Thanks in advance. What I am trying to achieve: Conditional formatting a cell based on 2 conditions (The value in the cell i want to colour and also in another column). What I currently h...
You may want to have a word with your Accessibilty experts.
See attached.
Hi lbenlin, Thank you for your reply. This definitely works as intended in my table! thanks so much. I have now change this table into a matrix and added another 2 rows on top to group it by the Location and Team the staff are working in.
Looks like this now (Please see comments):
| Staff Name | Leave taken on 1st June 2023 | Timesheet hours submitted for 1st June 2023 | Comments | |
| Location1 | Team 1 | False Positive Issue: When collapsed this Location1 row is coloured pink | ||
| Alice | 1 | 0 | ||
| Alex | 0 | 40 | ||
| Location2 | Team 2 | This appears to be correct when collapsed because there is one Staff (Barb) that meets the conditonal criteria. | ||
| Bob | 0 | 40 | ||
| Barb | 1 | 40 | ||
| Location3 | Team 3 | This appears to be correct when collapsed because there is one Staff (Cameron) that meets the conditonal criteria. | ||
| Cameron | 1 | 40 | ||
| Callum | 0 | 40 |
Follow on Question:
- Once I add 'Location' and 'Team Names' to the matrix (Each team has more than one person in them), I can see that your measure is applying the colour formatting to the row total when I fully collapse the rows. When I fully expand the matrix, inside the Teams that were coloured (when collapsed), there are no staff in that Team who have both cells populated. It appears to be applying the formula at which ever level is open. Can this be fixed?