+ Reply to Thread
Results 1 to 7 of 7

Highlight the range of selected cell

  1. #1
    Forum Contributor
    Join Date
    08-06-2006
    Location
    Spain
    MS-Off Ver
    Excel 2010 32Bit
    Posts
    359

    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

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Highlight the range of selected cell

    With your formulas, when you get into 'EDIT' mode by pressing F2 while in the relevant cell you can see the highlighted ranges.

    Else you'll need a VBA code to achieve what you desire
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Contributor
    Join Date
    08-06-2006
    Location
    Spain
    MS-Off Ver
    Excel 2010 32Bit
    Posts
    359

    Re: Highlight the range of selected cell

    Thank you Ace_XL for your quick reply,

    Yes into EDIT mode highlight the ranges,

    But I wish if it could be possible to have VBA solution

    Regards,
    Moti

  4. #4
    Forum Contributor
    Join Date
    08-06-2006
    Location
    Spain
    MS-Off Ver
    Excel 2010 32Bit
    Posts
    359

    Re: Highlight the range of selected cell

    It has just occurred to me that other than VBA could there be any worksheet function that can highlight formula cell range once the cell is selected.

    Regards,
    Moti

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Highlight the range of selected cell

    To the best of my knowledge, there are no regular functions that will just highlight a range for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Forum Contributor
    Join Date
    08-06-2006
    Location
    Spain
    MS-Off Ver
    Excel 2010 32Bit
    Posts
    359

    Re: Highlight the range of selected cell

    Thank you FDibbins

    I found some solution, which highlight the selected formula range but wipe out colour of my fix cell, which are A1:A5 & A1:K2

    Please will you check code below with my workbook Highlight ranges?
    Please Login or Register  to view this content.
    Is it possible that you do modified the code so the cells A1:A5 & A1:K2 must remain as original Blue with Fonts

    Regards,
    Moti

  7. #7
    Forum Contributor
    Join Date
    08-06-2006
    Location
    Spain
    MS-Off Ver
    Excel 2010 32Bit
    Posts
    359

    Re: Highlight the range of selected cell

    Here is the file attached with sub when you click any one of the formula cell, which are L4, L5 Or M5 will highlight the Range of that selected cell,

    But I am having problem that I can not fill the colour manually in cells A1:A5 & in cells A1:J2 for example I need to fill these cells Blue with white fonts as shown in my workbook Post#1

    And other thing with this code I cannot copy the cells and paste them to other place in the sheet.

    I will appreciate if any body can modify the range B2:M5, as formula range then may be this problem could solve. For now sub cells range is Cells(1, 1) which affect to whole sheet

    Also this sub goes to worksheet module preferable if it work only for worksheet.

    Please help

    Regards,
    Moti
    Attached Files Attached Files

+ Reply to Thread

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