+ Reply to Thread
Results 1 to 4 of 4

Conditional format or some formula to fill in Yes when you only type y and No for n

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    18

    Conditional format or some formula to fill in Yes when you only type y and No for n

    When I have spoken to a named person for the guest list and I type y in Column E and / or Column F it should fill in Yes and No for n

    Conditional format or some formula to fill in Yes when you only type y and No for n

    It seems what I have done only works when the top row it says yes then it follows with yes but not for No. but when I delete all it does not work
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,746

    Re: Conditional format or some formula to fill in Yes when you only type y and No for n

    Can you give some specific examples of what values you type in specific cells and what you expect to see and where.
    It's not at all clear to me at the moment how you are using this.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-19-2012
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Conditional format or some formula to fill in Yes when you only type y and No for n

    I am inviting people for a party and when I have spoken to an individual I write their name and contact number and in the column E and F when I have spoken to then I want to type y to fill in Yes and type n for No.

    I somehow got it working for yes (only few rows) but not for “No”

    Thankyou

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,746

    Re: Conditional format or some formula to fill in Yes when you only type y and No for n

    Conditional formats can't change what's in a cell. All they can do is change what the cell looks like or displays

    You appear to be using the autofill functionaility. This is usually used to suggest words as you type the characters.
    However this requires there to be a list of allowable words, in your case yes and no in cells that are contiguous with the cells you want to complete.
    So for instance you could add a new row one and in E1 enter yes and in E2 enter no. Now when you enter y in E5 it will prompt you to accept the wor yes.

    Note however if D5 & E5 was blank and you entered y in E6 you would not be prompted with 'yes' because there is not a contiguous range of non balank cells between E6 & E1

    Your other option is to use a VBA Sheet Change macro which could enter yes when y is input.

+ 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. Replies: 12
    Last Post: 02-19-2018, 12:32 PM
  2. Replies: 3
    Last Post: 02-24-2015, 02:58 AM
  3. [SOLVED] Conditional Format to fill whole cell
    By mrr2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-17-2012, 08:09 PM
  4. Replies: 3
    Last Post: 08-04-2012, 07:22 PM
  5. Auto fill type formula
    By CoronaC in forum Excel General
    Replies: 11
    Last Post: 03-03-2011, 02:03 PM
  6. can formula If type into conditional format ?
    By choy96 in forum Excel General
    Replies: 2
    Last Post: 12-22-2010, 12:21 PM
  7. Excel 2007 : Changing Fill FX Changes Conditional Format?
    By BrokenBiker in forum Excel General
    Replies: 2
    Last Post: 03-28-2009, 05:09 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