Results 1 to 6 of 6

Thread: Filling A Number Of Cells Based On Numerical Value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-12-2013, 05:50 PM #1
    Ryan_Bernal
    Ryan_Bernal is offline
    Member Ryan_Bernal's Avatar
    Join Date
    Dec 2012
    Posts
    37
    Rep Power
    0

    Filling A Number Of Cells Based On Numerical Value

    Hello guys,
    Good day!
    Need help regarding on this.
    I just want to filling A Number Of Cells Based On Numerical Value.
    So that it will tell the user to input only on the filled cells.
    Let say B3 is the numerical value and the cells to be filled is from range E3:N10
    The value of B3=5 then the cells should be fill are range E3:I5.
    When there is data that will be inputted after I5 the cell will filled with red color.
    Here is my workbook.
    Thanks in advance.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sum Of A Row of Cells In Multiple Columns Based On Criteria And Column Index
    By excel_learner in forum Excel Help
    Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  2. Make cells visible based on Data Validation criteria
    By IJC in forum Excel Help
    Replies: 4
    Last Post: 05-05-2013, 04:01 AM
  3. Need a way to conditionally format a cell based on an adjacent cells value.
    By Orestees in forum Excel Help
    Replies: 2
    Last Post: 01-24-2013, 09:03 PM
  4. Concatenating array into cells based on conditions
    By Lis7 in forum Excel Help
    Replies: 1
    Last Post: 12-04-2012, 08:56 AM
  5. Format Cells Based on Given Input
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 10
    Last Post: 08-23-2011, 11:19 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