+ Reply to Thread
Results 1 to 2 of 2

How do you automatically fill cells with a specific word depending on the cells colour?

  1. #1
    Registered User
    Join Date
    06-11-2016
    Location
    London
    MS-Off Ver
    Office 2016
    Posts
    19

    How do you automatically fill cells with a specific word depending on the cells colour?

    Hi guys,

    How do you automatically fill cells with a specific word if a specific colour is filled in?

    So imagine I want to highlight 10 cells in red and by doing so, I want the word 'chair' to appear automatically. This is essentially the opposite of conditional formatting where a cell changes colour depending on the cell value.

    Thank you!

    Alex

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: How do you automatically fill cells with a specific word depending on the cells colour

    It's easy to do manually if (as I suspect) all coloured cells are in one column.
    Select this column (or whole table), apply autofilter, use Filter by colour. select all visible cells (red) and in formula bar write 'chair" and press Ctrl+Enter
    remove filter and you will see "chair' added only to the cels which were selected by filtering.

    To do it fully automatically: will be not as easy as CF.
    Especially if conditional formatting behaviour is to be reflected (you fill new cell with red, and there automatically appears 'chair' in it).
    But even if you want to use some command: OK, now search the worksheet and put 'chair' in all red cells - it will require some coding (macro).
    Best Regards,

    Kaper

+ 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. Fill colour cells in a row automatically
    By djmcdee in forum Excel General
    Replies: 1
    Last Post: 06-11-2013, 10:55 PM
  2. [SOLVED] Cells to change colour depending on specific text
    By Fran Habbitts in forum Excel General
    Replies: 4
    Last Post: 12-11-2012, 10:50 AM
  3. Fill cells depending on colour?
    By Mattneedshelp in forum Excel General
    Replies: 1
    Last Post: 04-23-2012, 11:00 AM
  4. Count cells with a specific fill colour
    By BrianJC in forum Excel General
    Replies: 3
    Last Post: 01-09-2012, 07:30 PM
  5. Replies: 3
    Last Post: 07-08-2010, 06:48 PM
  6. Automatically Changing fill colour in cells
    By frazzled in forum Excel General
    Replies: 3
    Last Post: 08-29-2009, 03:28 PM
  7. changing a cell depending on the fill colour of adjacent cells
    By debbiec in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-21-2009, 06:11 AM
  8. Automatically colour fill cells
    By svn_pie in forum Excel General
    Replies: 3
    Last Post: 11-24-2007, 06:12 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