Results 1 to 7 of 7

Highlight the range of selected cell

Threaded View

Motilulla Highlight the range of... 07-06-2013, 04:58 AM
Ace_XL Re: Highlight the range of... 07-06-2013, 05:13 AM
Motilulla Re: Highlight the range of... 07-06-2013, 05:39 AM
Motilulla Re: Highlight the range of... 07-06-2013, 04:21 PM
FDibbins Re: Highlight the range of... 07-06-2013, 04:30 PM
Motilulla Re: Highlight the range of... 07-06-2013, 07:47 PM
Motilulla Re: Highlight the range of... 07-07-2013, 01:51 AM
  1. #1
    Forum Contributor
    Join Date
    08-06-2006
    Location
    Spain
    MS-Off Ver
    Excel 2010 32Bit
    Posts
    545

    Highlight the range of selected cell

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1