Hi,
And again, i need help from some bright "excellers".
This time, as per the attached screenshot, there is a table with 14 rows and 6 columns (A2:G17, A2 and A3 merged just to have the title "Name", then whole A4-A17 filled with names, B3-G3 filled with time slots).
14 rows corresponds to 14 users that enter their availability into 6 columns that represent time slots.
Users do that by choosing a value from the dropdown menu (there are two options "morning" which is being available for the defined time slot, "cours" which means unavailable or simply empty cell that also corresponds to not being available).
In total, i need to have 10 users to be available at any given time slot.
Meaning, every time slot column has to have at least 10 "green" cells.
If there are less than 10 "green" cells in any row, then merged cell "B2:G2" has to change background colour to red, otherwise, it changes back to no color.
I am having a problem with achieving that.
I basically need to have 10 users to cover all time slots.
The attached imager is an example of how users would fill that table up.
Please help. If possible without macros.
Thank you in advance.
And again, i need help from some bright "excellers".
This time, as per the attached screenshot, there is a table with 14 rows and 6 columns (A2:G17, A2 and A3 merged just to have the title "Name", then whole A4-A17 filled with names, B3-G3 filled with time slots).
14 rows corresponds to 14 users that enter their availability into 6 columns that represent time slots.
Users do that by choosing a value from the dropdown menu (there are two options "morning" which is being available for the defined time slot, "cours" which means unavailable or simply empty cell that also corresponds to not being available).
In total, i need to have 10 users to be available at any given time slot.
Meaning, every time slot column has to have at least 10 "green" cells.
If there are less than 10 "green" cells in any row, then merged cell "B2:G2" has to change background colour to red, otherwise, it changes back to no color.
I am having a problem with achieving that.
I basically need to have 10 users to cover all time slots.
The attached imager is an example of how users would fill that table up.
Please help. If possible without macros.
Thank you in advance.