Results 1 to 4 of 4

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

Threaded View

  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

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