+ Reply to Thread
Results 1 to 3 of 3

command button to fill color in cell based on text in another cell

  1. #1
    Registered User
    Join Date
    10-07-2013
    Location
    yorkshire, england
    MS-Off Ver
    Excel 2010
    Posts
    23

    command button to fill color in cell based on text in another cell

    It doesn't sound that hard but i've had no joy while searching.
    I have a weekly 'to do list'.
    In column A it states whether it is a daily job or the day of the week it gets done.
    In colunm B it states the time the job needs to be done by.
    In column C it gives a description of the job.
    I color the job description in when it is done.

    I want a command button the fills them back in white every morning, but leaves the rest colored/uncolored so i know what is done/not done.

    I want the code to look in column A for the word "Daily" and if its there then fill column C white (no fill).

    I use rows 2-150

    Thanks in advance

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: command button to fill color in cell based on text in another cell

    You can try running this macro, if it's fine, you can assign it to a button.
    Please Login or Register  to view this content.
    多么想要告诉你 我好喜欢你

  3. #3
    Registered User
    Join Date
    10-07-2013
    Location
    yorkshire, england
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: command button to fill color in cell based on text in another cell

    Perfect- thank you very much

+ 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. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  2. [SOLVED] Toggle fill Color in cell based on condition of cell--blank or text added.
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2014, 08:39 PM
  3. change fill color of a range of cells based on color of a cell?
    By DarMelNel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 04:48 PM
  4. Replies: 10
    Last Post: 06-19-2013, 05:28 PM
  5. [SOLVED] A macro or command that can look at a range of numbers and assign a fill color to the cell
    By dmackco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2012, 10:12 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