Results 1 to 7 of 7

Thread: fill in cells according to selected optionbutton

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 09-11-2013, 11:06 AM #1
    paul_pearson
    paul_pearson is offline
    Senior Member
    Join Date
    Mar 2013
    Posts
    107
    Rep Power
    12

    fill in cells according to selected optionbutton

    Hi

    I have the cells fill in with color for Production,Planned Stop and Internal for Machine Stoppage......

    1. How can the code be changed so that when Machine Stoppage is used it fills in the cells (eg XFLOW A Sheet) with color depending on which is selected between Internal or External...i can get it to fill in for Internal but not External

    2. When Daily Total is selected (commandbutton) it also colors the rows where all Sum Totals are ... can the rows which have any Totals and Grand Totals entered have NO color in these rows

    Thanks

    PP
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Fill ComboBox With Values From Corresponding Dynamic Column Based On Value Selected
    By paul_pearson in forum Excel Help
    Replies: 1
    Last Post: 08-20-2013, 04:31 PM
  2. Table Or Array That Can Auto Fill In Column Information Based On Two Cells Text Value
    By william516 in forum Excel Help
    Replies: 9
    Last Post: 08-02-2013, 07:55 PM
  3. Unmerge Cells and Fill with Duplicate Values
    By princ_wns in forum Excel Help
    Replies: 3
    Last Post: 10-09-2012, 07:36 AM
  4. List selected filenames in an Excel range of cells
    By TomyLee in forum Excel Help
    Replies: 2
    Last Post: 09-24-2012, 06:24 PM
  5. Import Specific cells from Excel only selected date records.
    By Raj Kumar in forum Access Help
    Replies: 0
    Last Post: 02-27-2012, 01:07 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
  •  

Forum Rules