Results 1 to 9 of 9

fill cells with yes if a value is true

Threaded View

  1. 05-17-2015, 11:15 PM #1
    Iain Clarendon
    Iain Clarendon is offline
    Registered User
    Join Date
    05-17-2015
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    21

    fill cells with yes if a value is true

    I have a spreadsheet with week 1, week 2 across columns for 1 year.
    In a row I have the frequency drop down 1w (which = 7 days), 2w (which = 14 days)
    I would like to return "yes" in the cells below week 1 if the frequency = 1w. Same with select 2w and every second week the cell returns "yes"
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Fill row if condition is true
    By norlax in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-20-2014, 01:05 PM
  2. Fill Cell with a certain color if item is true
    By Ian Claydon-Butler in forum Excel General
    Replies: 1
    Last Post: 02-24-2014, 11:13 AM
  3. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  4. Fill if True
    By bnwash in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-11-2012, 03:27 PM
  5. Auto Fill cells in a Column. Fill down from preceeding cell, using a formula.
    By tsa8786 in forum Excel General
    Replies: 1
    Last Post: 09-07-2011, 05:57 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1