+ Reply to Thread
Results 1 to 5 of 5

Sort conditional formatting

  1. #1
    Registered User
    Join Date
    12-16-2006
    Posts
    26

    Sort conditional formatting

    I have read and read the 'How to', but I'm completely baffled as to how I can create cells in column J (file attached) to reflect the red text colour cells in column B which will then allow me to do a sort on that conditional formatted B column.
    If I understand correctly I need to get the column J cells to say yes or no and the sort will work.
    Could someone please give me the answer?
    Attached Files Attached Files
    Last edited by meridklt; 10-18-2007 at 02:38 PM.

  2. #2
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Washington, DC
    Posts
    103
    Click on B1 then Format / conditional formating
    This will show you the formula associated with the red text. Copy that formula "=NOT(ISERROR(VLOOKUP(B1,F:F,1,FALSE)))" into cell J1 and then past down

  3. #3
    Forum Contributor
    Join Date
    08-30-2007
    Location
    Vancouver, B.C.
    Posts
    149
    on a sepearte column, enter your conditional formating formula, then hide the column.

    Sort by that hidden column

    Please Login or Register  to view this content.

  4. #4
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    NOT(ISERROR is a rather more elaborate construction than you need for the conditional formatting. You can use

    =COUNTIF(F:F,B1)

    then the formula in column J can, similarly, be

    =COUNTIF(F:F,B1)>0

  5. #5
    Registered User
    Join Date
    12-16-2006
    Posts
    26
    Thanks for the help chaps, but I still am unable to sort with any of your suggestions. I still end up with the J column content as column B is and not displaying with a 'YES' 'NO' text to sort on.
    I have attached a new file incorporating your suggestions in their own worksheet. So could you be so kind as to explain where I'm going wrong with your answer and perhaps attach the corrected file to your reply.
    Attached Files Attached Files
    Last edited by meridklt; 10-18-2007 at 04:42 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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