Hello everyone,
Please see the attached file Highlight Ranges for details
Formula in cell L4 =IF(ROWS(L$3:L4)<2,0,SUMPRODUCT(--($B4:$J4=1),--($C3:$K3=1)))
I want when I select the cell L4 Range $B4:$J4 & $C3:$K3 could be highlight as shown
Formula in cell M5 =SI(FILAS(M$3:M5)<3;0;SUMAPRODUCTO(--($B5:$I5=1);--($C4:$J4=1);--($D3:$K3=1)))
I want when I select the cell M5 Range $B5:$I5& $C4:$J4 & $D3:$K3 could be highlight as shown
Colour does not matter only I want to see selected formula range highlighted
Please Help
Bookmarks