Forum Discussion
Index Match Conditional formatting
I have two tables There are for instances unique employee ID in look up column and then dates like on column DB8. Table 1 - Table 2 - is the holiday table it matches the employee ...
Thanks, the conditional format says enter a valid formula -
below is the formula -
IF( AND( MATCH($E145, 'Leave Chart - Weekly - Auto'!$A$2:$A$293, 0), MATCH('Forecast Data (Current)'!DB$8, Table_Leave_Chart___Weekly___Auto[[#Headers],[01/07/2023]:[30/12/2023]], 0), INDEX('Leave Chart - Weekly - Auto'!$A$2:$A$293, MATCH('Forecast Data (Current)'!$E145, 'Leave Chart - Weekly - Auto'!$A$2:$A$293, 0), MATCH('Forecast Data (Current)'!DB$8, Table_Leave_Chart___Weekly___Auto[[#Headers],[01/07/2023]:[30/12/2023]], 0)) ) > 8, TRUE, FALSE )
below is the formula -
IF( AND( MATCH($E145, 'Leave Chart - Weekly - Auto'!$A$2:$A$293, 0), MATCH('Forecast Data (Current)'!DB$8, Table_Leave_Chart___Weekly___Auto[[#Headers],[01/07/2023]:[30/12/2023]], 0), INDEX('Leave Chart - Weekly - Auto'!$A$2:$A$293, MATCH('Forecast Data (Current)'!$E145, 'Leave Chart - Weekly - Auto'!$A$2:$A$293, 0), MATCH('Forecast Data (Current)'!DB$8, Table_Leave_Chart___Weekly___Auto[[#Headers],[01/07/2023]:[30/12/2023]], 0)) ) > 8, TRUE, FALSE )
Please provide detailed information.
Excel version, operating system, storage medium, etc.
A file (without sensitive data) would also be helpful.
Excel version, operating system, storage medium, etc.
A file (without sensitive data) would also be helpful.
- Hi,
Excel version - Microsoft® Excel® for Microsoft 365 MSO Version 2208 Build 16.0.15601.20676 32-bit
operating system - Microsoft Windows
storage medium - it's stored in a folder. but would want to move it to sharepoint.
Thanks