+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting based on several conditions

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    15

    Conditional formatting based on several conditions

    Hi,

    I am trying to do some conditional formatting to highlight rows based on several conditions, I don't know if this is possible, but these are the criteria:

    AAPL tt 10/1/2013 11:14:15
    GOOG ll 10/1/2013 11:14:20
    AAPL ff 10/1/2013 11:14:31
    AAPL rr 10/2/2013 14:52:30

    I want to highlight a row if:
    - the difference in time value is < 20 seconds
    - the first symbol column is the same
    - at least one, but not all of the rows meeting the above criteria contains a value in the second column from a given list (in this example, say tt is on this list)

    So if done properly the logic would highlight the first and third rows, but would highlight none if none of the values in column two match my list.

    I think the test criteria would go something like this, however I know that there are problems with my row references.

    =and(abs($C2-$C3:$C65536)<0.0003,$A2=$A3,match($A2,Sheet1!A:A,0)>0)


    Please let me know if this is clear or you would like more details.

    Thanks,

    T
    Last edited by dicenn; 10-11-2013 at 12:14 PM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,952

    Re: Conditional formatting based on several conditions

    Hi,
    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.



    View Pic

  3. #3
    Registered User
    Join Date
    11-27-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Conditional formatting based on several conditions

    Thanks for the reply,

    Here is some randomized sample data. The first sheet, RawData shows the before, and the FormattedData sheet shows what should be highlighted after the conditional formatting.

    Again, the highlighting is based on all of the following criteria:

    Time difference of < 20 seconds
    Matches in the symbol column
    Matches in the name column to the 'Flag list' at the top, however should only be highlighted if there is at least 1 match, but not all names match the flag list

    I hope this is clear. Let me know if you need additional details.

    Thanks,
    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)

Similar Threads

  1. [SOLVED] Conditional Formatting Based Upon Many Conditions
    By sdoern20 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-17-2013, 06:03 AM
  2. Conditional Formatting based on two conditions
    By SLickid9 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-02-2013, 03:52 AM
  3. [SOLVED] conditional formatting based on 2 conditions
    By wav87 in forum Excel General
    Replies: 4
    Last Post: 09-18-2012, 01:11 AM
  4. Conditional Formatting based on 3 conditions
    By nycdave in forum Excel General
    Replies: 3
    Last Post: 05-23-2011, 01:48 PM
  5. Conditional formatting based on conditions in other cells.
    By manxman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2006, 12:50 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