Conditional Formatting Help #4

If cell c6 says:    ----------------------------     I would like to
have D6 automatically say

Approved      ----------------------------           25%
or
Design    ----------------------------                 50%
or
Build     ----------------------------                   75%
or
Shipped   ----------------------------               100%


Any Ideas????

Thanks

John


-- 
John Doe
------------------------------------------------------------------------
John Doe's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26826
View this thread: http://www.excelforum.com/showthread.php?threadid=400756

0
8/31/2005 12:53:06 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
332 Views

Similar Articles

[PageSpeed] 24

Try this:

=IF(C6=0.25,"Approved",IF(C6=0.5,"Design",IF(C6=0.75,"Build",IF(C6=1,"Shipped",""))))

"John Doe" wrote:

> 
> If cell c6 says:    ----------------------------     I would like to
> have D6 automatically say
> 
> Approved      ----------------------------           25%
> or
> Design    ----------------------------                 50%
> or
> Build     ----------------------------                   75%
> or
> Shipped   ----------------------------               100%
> 
> 
> Any Ideas????
> 
> Thanks
> 
> John
> 
> 
> -- 
> John Doe
> ------------------------------------------------------------------------
> John Doe's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26826
> View this thread: http://www.excelforum.com/showthread.php?threadid=400756
> 
> 
0
8/31/2005 1:20:05 PM
Reply:

Similar Artilces:

identity removal help!
My son added a password to an identity for an email account. He doesn't remember the password. Any way to remove the indentity in outlook express Hi, JC - This is a group to support Outlook from the Office group of programs. Outlook Express is a part of Internet Explorer and is a quite different program, despite its similar name.. You will probably get a faster and more expert answer if you post this to an Outlook Express news group. Try posting in one of these newsgroups: microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x microsoft.public.windows.inetexplorer.ie55....

combine 4 file into one
I have one excel file. This file consists of Item Number, Description, Quantity, Unit Cost and Extended Value. I send this file to 4 users in various locations so they can open in the MS Excel. The users will count how many quantity they have for each Item number. The user then saves and sends the file back to me. My question is how do I combine four files from 4 users back into one file with the quantity update and other fields remain unchanged. For instant, User A count 4 for the item 12345, User B count 2 for the item 12345, User C count 1 and User D count 0. How do I combine 4 files f...

Today Conditional Format
I have a column which calculated a date based on 3 working days from a date input into a diff column. What I want to do I have the calculated date appear bold if that date has passed based on the current date. For example if I input 01/08/11 the next column calculates 04/08/11 (3 working days). I want the caluclated date to appear bold when I open the spreadsheet on the 05/08/11 ro show the calculated date has passed. I can use conditional formatting but can't get the syntax right Regards Andy Win XP Pro Office 2010 Andy Roberts presented the following explanation : > I ha...

Printing Help
I know there should be an easy way to do this, but I have yet to figure it out. I have a 183 page report on school districts. I want to print all the information for one school district per page (or possibly two because a few of the larger districts might take up two pages.) On the report, I have one district per page or two and I could just print the whole thing but I don't want to. Is there a way to print a certain district? I don't want to just print page 42 and wonder what district that is. I want to print, let's say Spring School District, and only that page prints. Th...

Can't format numbers for France in Excel 2003
I'm using the US version of Excel 2003, but need to format costs, etc., for a project in the French euro format (e.g., I need 2050.45 euros to display as 2 050,45). That currency format isn't offered in my dialog box, and if I make a custom number format that will display correctly, it doesn't operate as a number. Any suggestions? On Wed, 10 Oct 2007 08:51:03 -0700, Mary Fran <MaryFran@discussions.microsoft.com> wrote: >I'm using the US version of Excel 2003, but need to format costs, etc., for a >project in the French euro format (e.g., I need 2050.45 euros...

SelectNodes starts-with XPath help
I have the following XML: <folder name="global"> <folder name="_images"> <file name="creative_apply_txt.jpg" /> <file name="creative_culture_txt.jpg" /> <file name="push_btn_submit.gif" /> </folder> <folder name="en"> <folder name="_images"> <file name="creative_apply_txt.jpg" /> <file name="creative_home_txt.jpg" /> <file name="header_email_notice.gif" /> </folder> </folder> </folder> A...

trying to split a stock 1:4
When I were trying to split a stock using Money2000, Money2000 ended up telling me: "The stock split can not be completed due to a lack of disk space." But I still have 18G left on my hard disk. In microsoft.public.money, Wei wrote: >When I were trying to split a stock using Money2000, >Money2000 ended up telling me: "The stock split can not >be completed due to a lack of disk space." But I still >have 18G left on my hard disk. I would try booting into Safe Mode and see if you can do the split. I don't expect it to solve the problem, but it is ea...

Two Condition Vlookup?
I am currently trying to create a function that searches through an array for two exact column values which allows me to retrieve a third column value. For example: Type of Fruit Date Packaged Amount of Fruit Apples June 100 Oranges June 50 Apples July 75 Grapes July 50 In this example, I would be looking to retrieve the Amount of Fruit (Apples) that was packaged in July. I would be putt...

help 04-20-10
since yesterday when ever i try and open an icon on my desk top this message comes up windows cannot access the specified file, pathway you may not have permission to access it? what does this mean and how do i fix it???? Also about a week ago when i was on the internet these system messages kept coming up saying my computer was in trouble and peple were trying to access my personal information and i needed to upgrage my spyware. i couldnt go into any programes except the windows security site and then i had to buy the 6 month protection to access anything on my computer. now ...

Query condition by date range
I'm trying to create a query to base a report from. I need it to return records within a date range that needs to be specified, as in specifying the beginning date and having the current date as the end date. A field is included in the query that has listed dates in the format mm/dd/yyyy. How would I write the criteria? I have part of it ready - [Please enter starting date:] . I know that's how you get the little question window. On Tue, 4 Dec 2007 14:51:00 -0800, silva wrote: > I'm trying to create a query to base a report from. I need it to return > records within a...

Help with an IF statement please...
Hello all... I have a column with these values (A+, A, A-, B+, B.....) and I am trying to assign numerical values to each grade I thought I had the formula down but I keep getting error messages... can you please tell me what I did wrong... Here is what I tried to enter... =if((if(D143="A+","100",IF(D143="A","95",IF(D143="A-","90",IF(D143="B +","89",IF(D143="B","85",IF(D143="B-","80",IF(D143="C +","79",IF(D143="C","75",IF(...

Help with Google Groups search
Forgive me for this off-topic request. But since it impairs my ability to help people with Excel questions, it might not be entirely inappropriate. I have not gotten constructive help through the Google Groups forums in the past for similar problems. If you can find the following article using Google Groups Advanced Search, please let me know how you did it field-by-field. Feel free to respond in email; send to joeu2004 "at" hotmail.com. The article is: Thread-Topic: conditional format cells by date From: <Simon@discussions.microsoft.com> Subject: conditio...

Need help with conditional formula (Excel 97)
Can anyone give me the correct syntax for the following formula: if A1 is blank, and B1 is more than zero, then display B1, otherwise display nothing (blank cell) Thank you JD =IF(AND(A1="",B1>0),B1,"") Success! -- met vriendelijke groetjes "Jake D" <JakeD@djhtend.com> schreef in bericht news:crkto4lv30u7uujv27ek8okr0us5t9oj10@4ax.com... > Can anyone give me the correct syntax for the following formula: > > if A1 is blank, and B1 is more than zero, then display B1, otherwise > display nothing (blank cell) > > Thank you > > ...

Conditional formatting if condition of an if statement is true and a string value is displayed
Dear Experts: I got a nested 'IF'-Formula in an excel cell that returns nothing if the condition is false. I would like to conditionally format this cell with grey shading if the condition is true and a string value is displayed. How can this be achieved using excel conditional formating functionality ? Help is much appreciated. Thank you very much in advance. Regards, Andreas Let's say your doing this conditional formatting in cell K17. In conditional formatting (xl2003) choose the FormulaIs: option and enter: =$K$17<>"" choose your formatt...

Format cells #7
I have Excel 2000, Win ME. Recently the pulldown command to format cells does not always respond - ie, no box appears, so I can't apply borders or control number format. The shortcut approach doesn't work either. I've tried Help..Detect and Repair but the fault remains. Any suggestions welcome. ...

Formatting worksheet
I have a workbook with three worksheets and one chartsheet in it. I have notes documenting various aspects of the four sheets. Some of those notes are on electronic post-it notes and others on scraps of paper. It seems to me that a convenient way to consolidate all of my documentation for the workbook would be to add another worksheet to it and put the information in it. What would be the best way to format the worksheet so that I could type information into it as if I were using a text editor? Leslie, Excel isn't really all that set up for text. I sometimes make narrow column...

Please Help....urgent
Hi, I am doing notes to exchange coexistence & am facing an issue. I have following Microsoft Document NotesDirandMailMigrat word by word & still the connector is not working at all. Issue : As soon as I start to sync directory using Notes connector, several events are logged in event viewer.. few of these are : -no Notes Session Open -Error {GRC:a}: The application failed to initialize. -Initializing Lotus Notes Interface -Failed to initialize the NOTES subsystem I am running Exchange 2003 SP2. The connector i have installed is from Exchange CD and SP2 reapplied after install. ...

Outlook Certification Help
Do you need additional proof that you are an Outlook genius? Would you enjoy the respect and additional income that could come from being able to help everyone in your office on Microsoft Outlook? Get your Outlook Specialist certification and realize the benefits it can have. "Are You Certifiable (In Outlook, At Least)" is available at http://www.linkemup.us/areyoucertifiable.htm for only $18. It will go through each subject on the test and help you to prepare for this certification. If you do not plan to get certified but need a little extra help on using Outlook it is an excell...

Help needed on generating sequences
Hi all, in a excel sheet i want to generate the following sequences for some array of numbers let us say starting from 0 and going to N-1 bits, the sequence is from the Hamming Code. For clarity reasons i want to put a formula in excel that can show me which bit is to be checked as follows: Position 1: check 1 bit, skip 1 bit, check 1 bit, skip 1 bit, etc. (1,3,5,7,9,11,13,15,...) Position 2: check 2 bits, skip 2 bits, check 2 bits, skip 2 bits, etc. (2,3,6,7,10,11,14,15,...) Position 4: check 4 bits, skip 4 bits, etc. (4,5,6,7,12,13,14,15,20,21,22,23,...) Position 8: check 8 bits, skip 8 bit...

Conditional Field in Queries
Is there a way to make a field in a query conditional so that it only displays the value if the value is equal to something specifically set? Thanks. Nick Nick.Korynski@gmail.com wrote: > Is there a way to make a field in a query conditional so that it only > displays the value if the value is equal to something specifically > set? Thanks. > > Nick Explain "the value is equal to something specifically set". -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com ...

XML validation error. Help required
XML validation error. Help required If anyone can help me, thankyou, thankyou... When I run this code code I get this error: The data at the root level is invalid. Line 1, position 39. I can't work out what the error is. Can you??? original code: Dim oRead As XmlTextReader Dim oValid As XmlValidatingReader Try oRead = New XmlTextReader("C:\custdoc.xml") oValid = New XmlValidatingReader(oRead) AddHandler oValid.ValidationEventHandler, New Schema.ValidationEventHandler(AddressOf ValidationError) oValid.Schemas.Add("newschema", "C:\custschema.xsd") oValid....

zip codes not being saved as text in CSV format
I need my file to be saved in CSV format (to import into another application). When I format the zip codes as Text or Special(zip code), they are correct in XLS format, but when I open the file in CSV format they switch back to general. Any solution? work around? Thanks so much for your help in advance!! Melissa Change the file extension to .txt and use the text import wizard to treat the column as text (last dialog) -- Regards, Tom Ogilvy "MelissaM" <MelissaM@discussions.microsoft.com> wrote in message news:B5A02627-810E-4234-8247-267D9B12FA29@microsoft.com... >...

format a column
I have a simple question to ask, I have a column in Excel is number like 142000, I want to format the whole column numbers without the two ending 0s, change 142000 to 1420, how can I do that? Thanks -- xcao ------------------------------------------------------------------------ xcao's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14538 View this thread: http://www.excelforum.com/showthread.php?threadid=471821 Enter 100 in an empty cell and copy it. Then, select your range of numbers you want to change, Right Click and go to Paste Special, and select Div...

How do i use Conditional formatting for 3+ conditions ?
I have a text box in a report which highlights in colour current members in a list of past and present member names. I have six types of current members that I want to highlight, but with conditional formatting I can only use 3 conditions in the members [Type] field. I have tried [Type]="Full member" Or "Life member" but the "Or" doesn't work ! Is there a way to do this ? thanks .. Roger CF is limited to 3 contitions, but you can use OR in those expressions. If you set Condition1 to Expression, you can use: ([Type] = "Full member") Or (...

How to return a 12 hour time format without the AM in an Access query
The format function acts differently in a query and after hours of testing, messing, and cursing, I give up. How do you return 12 hour format without the AM or PM from an Access query. In my table, I've defined the Start Time and End Time to use "Medium Time" format and it works if and ONLY if you simple include the field in the query. However, if you use the field in a more complex statement, it returns leading zeros and trailing seconds. Here's what I've tried.... 'This didn't work because it returns trailing seconds and AM/PM. '2:00:00 PM...