+ Reply to Thread
Results 1 to 2 of 2

Highlighting Cells

Hybrid View

  1. #1
    Registered User
    Join Date
    10-17-2014
    Location
    MN
    MS-Off Ver
    2010, 2013
    Posts
    29

    Exclamation Highlighting Cells

    I need to highlight 1 cell below the "TRAY OF 38 POTTED PLANTS". "TRAY OF 38 POTTED PLANTS" will already be highlighted in yellow, so how can I highlight one cell below it? My list is pretty long. Here's example:

    TRAY1-T TRAY OF 38 POTTED PLANTS - 1 SPECIES
    LOB02F-T Lobelia cardinalis (Cardinal Flower)
    TRAY1-T TRAY OF 38 POTTED PLANTS - 1 SPECIES
    LOB06F-T Lobelia siphilitica (Great Blue Lobelia)
    TRAY1-T TRAY OF 38 POTTED PLANTS - 1 SPECIES
    MON02F-T Monarda fistulosa (Wild Bergamot)
    TRAY OF 38 POTTED PLANTS - 1 SPECIES
    Asclepias tuberosa (Butterfly Weed)
    TRAY OF 38 POTTED PLANTS - 1 SPECIES
    Monarda fistulosa (Wild Bergamot)
    TRAY OF 38 POTTED PLANTS - 1 SPECIES
    Rudbeckia subtomentosa (Sweet Black-eyed Susan)
    MIX & MATCH POTTED PLANTS - 6 SPECIES
    Aster novae-angliae (New England Aster)
    Echinacea purpurea (Purple Coneflower)
    Eupatorium maculatum (Joe Pye Weed)
    Monarda fistulosa (Wild Bergamot)
    Physostegia virginiana (Obedient Plant)
    Schizachyrium scoparium (Little Bluestem)
    TRAY OF 38 POTTED PLANTS - 1 SPECIES
    Iris virginica var. shrevei (Southern Blue Flag)

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,635

    Re: Highlighting Cells

    Select range starting in A2 use the following CF =isnumber(search("TRAY OF 38 POTTED PLANTS",A1)) and format as required

+ 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. [SOLVED] Need to validate contents of cells linked cells, highlighting those that require fixing
    By Hirad001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-23-2015, 09:37 AM
  2. Replies: 1
    Last Post: 11-12-2014, 10:57 AM
  3. Formatting cells other than select-highlighting the cells to apply the format?
    By Joe Miller in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-27-2014, 10:53 AM
  4. [SOLVED] Highlighting Cells if Specific Data Appears in Adjacent Cells
    By vinceancona in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2014, 06:33 PM
  5. Replies: 0
    Last Post: 02-05-2013, 07:51 AM
  6. Highlighting a range of cells dependant on data in any of those cells
    By Grimace in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2009, 02:34 AM
  7. Replies: 6
    Last Post: 08-28-2005, 05:05 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