Results 1 to 5 of 5

highlight specific row range

Threaded View

  1. #3
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: highlight specific row range

    You can highlight the specific rows using Conditional formatting too
    first select all cells of sheet
    then click Conditional formatting
    Click New rule----> use a formula to determine which cell to format
    use below formula
    =AND(ROW($A1)>=5,ROW($A1)<=10) This will highlight row 5 to row 10(in your case it should be =AND(ROW($A7333)>=5,ROW($A16000)<=10)
    then click format button select colour and hit ok

    see attached it is highlighting row 5 to 10 change the formula in CF to meet your requirement
    Attached Files Attached Files
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. highlight a specific cell in a range when changed
    By matt260384 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-17-2014, 11:53 AM
  2. [SOLVED] highlight when specific text appears multiple times in a range of cells - excel 2013
    By Onefynebarraza in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 10-14-2013, 09:06 AM
  3. Specific Text in Range then highlight cell
    By gingank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2013, 10:41 AM
  4. [SOLVED] Cond. formatting a column/Range, highlight cell in column/range if equal to specific text
    By DFrank231 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 03:35 PM
  5. [SOLVED] Highlight a range of cells if a single cell contains specific text
    By ZHertz in forum Excel General
    Replies: 3
    Last Post: 10-19-2012, 02:54 PM
  6. [SOLVED] Highlight cells of a particular value or within a specific range
    By DJS22867 in forum Excel General
    Replies: 3
    Last Post: 06-29-2012, 10:11 AM
  7. Highlight doubleclicked cells of a specific range
    By taya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2010, 04:40 PM
  8. highlight cells with values outside a specific range
    By excel_dumdum in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-21-2009, 09:40 PM

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