+ Reply to Thread
Results 1 to 3 of 3

Highlight Columns and Rows

  1. #1
    Forum Contributor
    Join Date
    10-17-2018
    Location
    Knoxville, TN
    MS-Off Ver
    Office 365
    Posts
    214

    Highlight Columns and Rows

    When I did research on my Title description I saw there were 7,293, so here is # 7,294. I need to know how to stop the cells outside of a grid to highlight what is in the grid since I already have a procedure to highlight a range of cells within the grid, and I am sure many of you are familiar with highlighting Rows and Columns. My attached file has all the information I need to fix if possible and I'm sure this has already been requested before.

    Thanks in Advance
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Highlight Columns and Rows

    Possibly...
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    10-17-2018
    Location
    Knoxville, TN
    MS-Off Ver
    Office 365
    Posts
    214

    Re: Highlight Columns and Rows

    dangelor, that stopped the outside cells from highlighting, but when you click on a Column (A,B,C etc or a Row 1,2,3 it highlights thru the grid and highlights the Column or Rows all the way to the end of the worksheet like it normally does.. That doesn't happen in the procedure I had. it stopped at the end of the range. It was just the outside of the grid that bothered me. Anyway, you fixed my concern and thanks.

    Jerry

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight rows that meet criteria in multiple columns
    By holtsmeister in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-16-2020, 09:22 AM
  2. Highlight Duplicate Rows based on Value on 2 different Columns
    By sunil31 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2019, 04:56 AM
  3. How to compare two columns and highlight and rows containing duplicates
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-12-2014, 04:47 PM
  4. code to highlight rows and add two columns
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-09-2013, 07:08 PM
  5. Replies: 0
    Last Post: 10-15-2012, 01:58 PM
  6. macro to compare columns and highlight common rows
    By jagman1990 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-22-2010, 12:27 PM
  7. Replies: 0
    Last Post: 11-28-2007, 06:46 AM

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