Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: Filter by Color not working

  1. #1
    New Member
    Join Date
    Mar 2011
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post Filter by Color not working

    Hi
    I am using Excel 2007 and suddenly I can no longer filter by color. The option is greyed out and so is the sort by Color option. Does anyone have any idea why this would happen?

    Thanks in advance.

  2. #2
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Filter by Color not working

    Is the file saved as an xlsx or xlsm or are you in Excel 97-2003 compatibility mode (xls).
    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    New Member
    Join Date
    Mar 2011
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filter by Color not working

    Hi
    File is saved as xlsx

  4. #4
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Filter by Color not working

    Hm. I thought that you might have been in compatibility mode http://technet.microsoft.com/en-us/l...ffice.12).aspx

    Does this happen even in a new workbook? Is the sheet protected?
    HTH, Peter
    Please test any code on a copy of your workbook.

  5. #5
    Board Regular
    Join Date
    Jul 2002
    Location
    Milton Keynes, England
    Posts
    11,044
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Filter by Color not working

    Quote Originally Posted by BarbaraPietersen View Post
    Hi
    File is saved as xlsx
    As well as answering VoG's questions can you tell us if there any other unusual settings for the workbook ( Shared mode maybe? )?
    Cheers, Glenn.

    Beauty is in the eye of the beer-holder.

  6. #6
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,399
    Post Thanks / Like
    Mentioned
    45 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Filter by Color not working

    Probably a silly question, but you do actually have some coloured cells in that column?

  7. #7
    New Member
    Join Date
    Mar 2011
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filter by Color not working

    Thanks all for responses. Answers in order:

    - This is the first time it has happened and appears to be only on this workbook
    - Sheet is not protected
    - I have colored cells right across the entire row

    Thanks again for any help

  8. #8
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,399
    Post Thanks / Like
    Mentioned
    45 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Filter by Color not working

    Did you apply the colour or is it the result of table autoformats?

  9. #9
    New Member
    Join Date
    Mar 2011
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filter by Color not working

    I formated rows by highlighting using color format (done it dozens of times)

  10. #10
    New Member
    Join Date
    Mar 2011
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filter by Color not working

    Sorry - except that they are cell colors and not font colors.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •