+ Reply to Thread
Results 1 to 3 of 3

moving cell to top of list based on colour of background

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    london
    MS-Off Ver
    Excel for mac 2011
    Posts
    75

    moving cell to top of list based on colour of background

    hi all

    does anyone know how i can create a script or macro in GOOGLE DOCS that can move a cell a specific colour to the top of list?

    then, say selecting a predefined colour palette of say 5 colours, each colour has a priority of order, so e.g..:

    red,green,yellow,blue,black

    if a cell anywhere has a red background it would be moved to top of list, then any cell in green would move to below the red cells,

    hope this makes sense to someone!!!

    thanks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: moving cell to top of list based on colour of background

    I have never used google docs, so I dont know if they support conditional formatting. It sounds like this is what you need to use, using a helper column to pull in the highest, 2nd highest etc, using =LARGE(range,1) etc and then using CF to color code them
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-25-2012
    Location
    london
    MS-Off Ver
    Excel for mac 2011
    Posts
    75

    Re: moving cell to top of list based on colour of background

    sorry im not good in excel, not familiar with the formulas, can you advise in layterms?!

+ 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] Show number in cell based on cell background colour
    By philjuk in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-11-2013, 02:04 PM
  2. Change background colour of a cell based on value of another cell
    By maryfay in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-07-2012, 10:25 AM
  3. IF formula based on background cell colour
    By mr_teacher in forum Excel General
    Replies: 1
    Last Post: 11-28-2007, 10:44 AM
  4. change a cell background colour to my own RGB colour requirements
    By Stephen Doughty in forum Excel General
    Replies: 4
    Last Post: 06-16-2006, 08:15 AM
  5. Changing Background Colour Based on Cell Contents
    By Sukh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2006, 09:00 AM

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