+ Reply to Thread
Results 1 to 4 of 4

Colour filter in Excel mobile

  1. #1
    Registered User
    Join Date
    10-01-2012
    Location
    Bromley
    MS-Off Ver
    Excel 2010
    Posts
    3

    Colour filter in Excel mobile

    Hello

    I have a seed sowing chart which uses the colour yellow to indicate which month to sow seeds. Seeds down the left and months across the top.

    Works fine when filtering by colour in Windows 10, but I want to filter an individual month by colour in Excel on my Android phone so that I can see only the seeds to sow for a particular month.

    Is this possible?

    Thanks

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Colour filter in Excel mobile

    Unfortunately no. Filter by color isn't supported in mobile or Excel Online.
    I'd recommend adding helper column that can be used as filter flag.
    Ex: 1 when you want to show the row, and 0/blank when row should be filtered out.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    10-01-2012
    Location
    Bromley
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Colour filter in Excel mobile

    Thanks CK76.

    I don't suppose custom views are supported either?

  4. #4
    Registered User
    Join Date
    10-01-2012
    Location
    Bromley
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Colour filter in Excel mobile

    Thanks CK76 for the idea of a helper column.

    A bit of thinking and I have solved it.

    In the cells that are yellow I put a 1 with a pen colour of yellow so that it is not seen.

    Put a 2 in the red cells with a red pen.

    That way I can filter in Excel on my Android phone without adding extra columns.

+ 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. Color filter not working in excel of android mobile
    By jpbisani in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 04-10-2018, 07:20 AM
  2. [SOLVED] Filter & remove incorrectly formatted mobile numbers
    By garryhope86 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-07-2015, 09:27 PM
  3. Is it possible to use the filter function in Google Docs through Android mobile phone?
    By otterandrews in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-14-2014, 03:00 AM
  4. Mobile Excel
    By tregrad in forum Excel General
    Replies: 12
    Last Post: 09-12-2011, 04:12 PM
  5. Excel Mobile Board
    By crs245 in forum The Water Cooler
    Replies: 3
    Last Post: 08-20-2009, 08:40 AM
  6. Excel Mobile VBA
    By mjbressler in forum Excel General
    Replies: 3
    Last Post: 09-08-2008, 12:07 AM
  7. [SOLVED] Filter arrow colour in Excel
    By Sue in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2005, 04:06 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