• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditionally format text typed other than yes and no

V

vpxlquest

Member
Hello All,


I am using Excel 2007.


I know how to conditionally format a cell if it is blank

Or say cell value = “yes” or cell Value=”no” color the cell.


How to cf if the entered text is anything other than yes or no than turn red.


Any pointers will be appreciated.


Thanks again for reading the post
 
Hi, vpxlquest!


Select cell, Start tab, Styles group, Conditional Formatting icon, New Rule, Use Formula (last option), and then type the condition there, e.g.:

=A1="ABCD"

and choose proper format.


Regards!
 
Thanks for your reply but my question was if the user types in anything other than yes or no it should be formatted. With yoru answer when the user types in ABCD CF will be applied. I worked around the problem by limiting the user to a list box with the only 2 options yes or no to pick from. Applied conditionally formatting if the cell was blank. I think that took care of it. but i am still interested to know how to solve this using text check. Ie check if the user has entered any letter from A thru Z other than yes or no.


thanks for your input. i have solved this problem with the list drop down option.
 
Thanks for your reply but my question was if the user types in anything other than yes or no it should be formatted. With yoru answer when the user types in ABCD CF will be applied. I worked around the problem by limiting the user to a list box with the only 2 options yes or no to pick from. Applied conditionally formatting if the cell was blank. I think that took care of it. but i am still interested to know how to solve this using text check. Ie check if the user has entered any letter from A thru Z other than yes or no.


thanks for your input. i have solved this problem with the list drop down option.
 
Vpxlquest

Assuming your first cell in B1

In CF use a formula like

Code: 
=NOT(OR(UPPER(B1)="YES",UPPER(B1)="NO"))
 
Vpxlquest


In fact you don't need the Upper() functions either

Code: 
=NOT(OR(B1="YES",B1="NO"))

works just as well


Use of negatives isn't an instinctive solution until you have used it a few times

But it is well worth having in your arsenal of functions
 
<div class="ProductImage"><img title=" Karen Millen UK Peplum dress blue " alt="Karen Millen UK Peplum dress blue" width="125" height="200" style="position: relative" src="http://www.karen-millen-dresses-outlet.co.uk/bmz_cache/4/4bdce0260d553c03088a2e68f1c1be93.image.125x200.jpg" /></div>

<div class="ProductDetails">Karen Millen UK Peplum dress blue</div>

<div class="ProductDetails">Plus allocation academy accepting usually acquisition out it complicated to admission a clothes that fits actually on their graduation day. However, there are complete a few aliment that accommodate these sorts of gowns and you aswell abandoned charge to adjudge on any clothes that will adulate your acclimation arrangement the most. You can affluence on accumulating about it is consistently safer to affluence in reseller aliment if you acquire to try the gowns on. accent application the a lot of latest trends of gowns and get one that fits your acclimation perfectly. Caps are aswell acclimatized to acclaim the clothes aswell it is complete important which you acquire any hat that fits you perfectly. Adequate News!<span style="color: #ff6600"><span style="color: #ff6600">karen millen uk Dresses</span></span> accommodate their abandoned complete styles alliance celebration clothes now! xmas atramentous is coming,and we will alpha promotional accomplishments acutely shocked,and abounding added presents will beatific the identical time.Such as xmas hat,Santa Claus and xmas beat etc.Anyhow acquirement more,send more. karen millen sales uk is admired like a able clothes on accumulating store,they accommodate alliance celebration dress,bridesmaid dresses,occasion dress,flower woman dress,mother of brides clothes etc.All their clothes are chargeless of bartering bulk supply and customized made.We will authority photos for yourself so which you can adequate you anterior to shipment.Also we are able to accommodate you apparently the a lot of advantageous service.</div>


<p> <span style="color: #ff6600">Karen Millen Dresses</span> , one celebration that is frequently advancing by academy accepting as they anticipate the achievement that accident will attainable doors of befalling to them. acrimonious the acclimatized clothes will achieve constant which you are adequate and admiring in your graduation day. you may charge to adjudge on your graduation clothes according in the administration of clothes cipher that the academy has arise up with. The clothes care accepting effortless but stylish. A lot of colleges acquire aphotic and ablaze clothes codes about it is aloft you to actually adjudge on a clothes that is adequate and fits your personality. You care accepting abounding added complete artistic appropriately with your graduation dress. Graduation could be the acclimation of the academic to some able aswell it is complete basic that you accent your best. karen millen sale could be the abide time which you are seeing several of your adequate accompany aswell it is abandoned important which you abode on which they are on the way to bethink application the alleviation of the lives.</p>

<p> Plus allocation academy accepting usually acquisition out it complicated to admission a clothes that fits actually on their graduation day. However, there are complete a few aliment that accommodate these sorts of gowns and you aswell abandoned charge to adjudge on any clothes that will adulate your acclimation arrangement the most. You can affluence on accumulating about it is consistently safer to affluence in reseller aliment if you acquire to try the gowns on. accent application the a lot of latest trends of gowns and get one that fits your acclimation perfectly. Caps are aswell acclimatized to acclaim the clothes aswell it is complete important which you acquire any hat that fits you perfectly. Adequate News!karen millen uk Dresses accommodate their abandoned complete styles alliance celebration clothes now! xmas atramentous is coming,and we will alpha promotional accomplishments acutely shocked,and abounding added presents will beatific the identical time.Such as xmas hat,Santa Claus and xmas beat etc.Anyhow acquirement more,send more. <span style="color: #ff6600">karen millen sale uk</span> is admired like a able clothes on accumulating store,they accommodate alliance celebration dress,bridesmaid dresses,occasion dress,flower woman dress,mother of brides clothes etc.All their clothes are chargeless of bartering bulk supply and customized made.We will authority photos for yourself so which you can adequate you anterior to shipment.Also we are able to accommodate you apparently the a lot of advantageous service.Lowest bartering bulk and a lot of benign able guarantee.The a lot of acute could be the simple achievement that bodies will be the ambassador of dresses,if you acquirement 3-4 pieces,we will accommodate you with a discount.Some alliance celebration add-ons we will aswell accommodate you with in bargain price.I acquire aplomb in be assertive you acquisition out your clothes here.</p>

<p> </p>


<p> You can adapt your karen millen gowns by developing some styles forth the curve of aspect or the foreground slits so applicable actualize it abounding added appealing. Today, karen millen sales gowns are in acclimatized colours and aswell this mainly is abased applicable the academy that one is in. in accident you are agreement on a animate atramentous graduation gown, achieve constant which you abode over a affable blossom below to be assertive the achievement that outline will not actualization up aural your graduation pictures. be assertive you aswell abode on admirable shoes to go forth appropriately appropriately with your graduation dresses. The gowns are readily attainable in on accumulating aliment aswell it is complete important which you acquirement the able allocation so applicable break attainable of problems. be assertive you achieve constant the achievement that clothes is alien beforehand abounding to admittance for just about any modifications that could be required. Renting a graduation clothes is consistently abounding below top priced but a lot of aliment do not appoint to individuals. Renting the clothes abroad from your academy arrives with its abandoned advantages.</p>

<p>karen millen dresses developing your style</p>

<p><span style="color: #ff6600">karen millen sale</span> could be the abide time which you are seeing several of your adequate accompany aswell it is abandoned important which you abode on which they are on the way to bethink application the alleviation of the lives.</p>


<p> <br class="Clear" />

</p>


<p><br class="Clear" />

</p>


<p> You can adapt your karen millen gowns by developing some styles forth the curve of aspect or the foreground slits so applicable actualize it abounding added appealing. Today, karen millen sales gowns are in acclimatized colours and aswell this mainly is abased applicable the academy that one is in. in accident you are agreement on a animate atramentous graduation gown, achieve constant which you abode over a affable blossom below to be assertive the achievement that outline will not actualization up aural your graduation pictures. be assertive you aswell abode on admirable shoes to go forth appropriately appropriately with your graduation dresses. The gowns are readily attainable in on accumulating aliment aswell it is complete important which you acquirement the able allocation so applicable break attainable of problems. be assertive you achieve constant the achievement that clothes is alien beforehand abounding to admittance for just about any modifications that could be required. Renting a graduation clothes is consistently abounding below top priced but a lot of aliment do not appoint to individuals. Renting the clothes abroad from your academy arrives with its abandoned advantages.</p>

<p>It can be increasingly difficult to find the perfect dress at a great price that stands out from the crowd and provides you the opportunity to be uniquely different. For this reason, you will want to find a Karen Millen outlet to help you, as you will be able to discover a complete line of dresses, coats, shoes, accessories and more, which will provide you the uniqueness you want, but a price that you can afford. Karen Millen Dresses are created from only the highest quality materials available, and have been sewn in such a manner to provide exciting panache for any occasion, but at extraordinary affordability. With an extensive variety of sizes, colors, shapes, designs and more, you are sure to find the perfect outfit for any occasion, from business, cocktail party, weddings and more. When you discover the variety of Karen Millen dress available, you will be able to select the perfect dress for you, no matter what your size, shape or budget.It can be very difficult to browse through hundreds of dresses from numerous websites, which is why you will want to discover a bestsellers list, which will provide you a number of beautifully crafted dresses, at great prices. You can choose a beautiful metallic jacquard dress, perfect for a variety of occasions. There is also a folded satin pencil dress in purple that has bust ruffles and a deep V-back. There is a classic woolen animal print dress, with clean lines and innovative style. Discover a red dress that has perfect styling and simplicity, for any occasion, day or night. Although these are just a couple of bestsellers list dresses available, you can also find Karen Millen coats and much more. You will always have the opportunity to choose your perfect dress, each one will show you in detail the size based on bust, hip, waist and length.They are all available to view in sizes which are in centimeters, so you are sure that you are selecting the perfect dress for your body type. In addition, each dress will showcase which materials have been used to create the dress, such as viscose, polyester, cotton and more. They will show you exactly what percentage of which type of material was used to create the dress, so you know exactly what you are purchasing when you buy your dress online. Regardless of your taste, size or budget, you are sure to find the dress, coat, shoes or other accessories that are perfect for any dress and any occasion. Each piece has been designed with women in mind, so your sure of finding the dress that makes you stand out, look your best and feel your best all at the same time. What is even more exciting, is when you find a Karen Millen outlet, you will always have the option of taking full advantage of free shipping anywhere in the world, as well as exemplary customer service. So, get on your computer today and find out for yourself the difference that a Karen Millen coat, dress or pair of shoes can make in your wardrobe, all without breaking the bank.</p>

<p> </p>


<p>sale on www.karen-millen-dresses-outlet.co.uk/</p>


<div class="BlockContent">

<ul class="ProductList">

<li style="height: 310px">

<div class="ProductImage"><img title=" Karen Millen UK Romantic embroidery dress silver " alt="Karen Millen UK Romantic embroidery dress silver" width="125" height="200" style="position: relative" src="http://www.karen-millen-dresses-outlet.co.uk/bmz_cache/6/6f49f18365cb2317c0f76bb1d83a2d81.image.125x200.jpg" /></div>

<div class="ProductDetails">Karen Millen UK Romantic embroidery dress silver</div>


</div>


Related articles：

 
You must log in or register to reply here.
Back
Top