Results 1 to 2 of 2

Highlight and extract

Threaded View

SMB618 Highlight and extract 02-22-2017, 02:40 AM
Sadath31 Re: Highlight and extract 02-22-2017, 03:23 AM
  1. #1
    Registered User
    Join Date
    07-05-2010
    Location
    Queensland, Australia
    MS-Off Ver
    Excel 2010
    Posts
    7

    Highlight and extract

    I want to use conditional formating to highlight and extract a value between a range.

    This range value will vary depending on stock market movement.

    In the example sheet attached, I have used Condition Formatting to highlight the range between 6490/6500. This range will vary with each days movement in the stock market.

    I just want to extract to a space or new sheet, where I can review in more detail, with the relevant supporting data (as highlighted and extracted as well)..i.e. Column A/B/C/D/E/F/K and S - and showing only Row 1 and 26.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight / Extract Deviating Values
    By JAspinall in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-28-2016, 07:32 PM
  2. Marco; extract to Word and highlight constant search terms?
    By jp09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2016, 04:26 AM
  3. Extract Min function and highlight cell from source
    By LeilaniMerle in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2014, 02:07 AM
  4. Replies: 2
    Last Post: 10-24-2012, 11:47 AM
  5. Replies: 2
    Last Post: 06-27-2012, 12:27 PM
  6. [SOLVED] highlight/remove highlight of rows conditional on cellvalue
    By timtim89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2012, 07:14 AM
  7. Replies: 5
    Last Post: 05-27-2005, 02: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