Forum Discussion
Solved
Conditional format cells based on overbooking of slot for a resource
Hi, I am trying to highlight resource in column A starting cell A2. Here I will list resources and many will come more than once. This resource shall be shown as booking in time slots starting co...
As variant
if I understood the logic correctly. M-4 shares Slot-7, thus also highlighted
Formula is
=SUMPRODUCT(--(MMULT(TRANSPOSE(--($A$2:$A$8=A2)),--($B$2:$N$8="x")) > 1))
As variant
if I understood the logic correctly. M-4 shares Slot-7, thus also highlighted
Formula is
=SUMPRODUCT(--(MMULT(TRANSPOSE(--($A$2:$A$8=A2)),--($B$2:$N$8="x")) > 1))