Conditional statements

[james]

I have three cells a1, b1 and c1 that should indicate green, yellow and red
respectively when values and range of values are given in say cell e1. The
values corresponding to the cells a1, b1 and c1 could be 100, 90 <=X<=95 and
<90 respectively. What formula should I use for each cell.
Thanks in advance

James

 

[Bob Phillips]

Don't start a new thread on the same topic, you will confuse and others will
get incomplete info.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Pete_UK]

Do you mean that E1 contains a value that you want to colour-code
according to the values in A1 to C1 ? Or do you want the values in
A1:C1 to be colour coded? What do you want to happen if you have a
value between 95 and 100 ?

Pete

 

[james]

Hi Pete
E1 contains a value that will return green for a1 or yellow for b1 or red
for c1 depending on the e1 value. I would have b1 to be yellow and all the
others blank if the value in e1 is between 95 and 100.

 

[james]

I am sorry david but its because I thought I hadnt made myself clear moreover
I am quiet new to excel and the these process. I hope you can help.

 

[David Biddulph]

If you want B1 to turn yellow if E1 is between 95 and 100, then in B1 use
Format/ Conditional Formatting/ Formula Is
=AND(E1>95,E1<100) then set your yellow pattern in the format options.

 

[james]

David thanks for your help but I dont understand what you mean by setting the
yellow pattern in the format options.

 

[james]

Sorry David but I am not getting any results

If you want B1 to turn yellow if E1 is between 95 and 100, then in B1 use
Format/ Conditional Formatting/ Formula Is
=AND(E1>95,E1<100) then set your yellow pattern in the format options.

 

[David Biddulph]

If you are using Format/ Conditional Formatting ..., you'll see a button
labelled Format... (on Excel 2003 it's at the right hand side of the
Conditional Formatting dialogue box for "Cell Value Is" or "Formula Is").
In there is a tab labelled "Patterns", and that will let you set the
background coulour of the cell to Yellow, or whatever other colour you
select, if the Conditions you specified are satisfied.

Your other thread (entitled "Formula" which is likely to make it difficult
to trace and follow - next time please use a more specific thread title) now
seems to be talking not of colouring the cell, but of putting the word
Yellow into the cell, in which case you don't want Conditional Formatting
but you merely need to enter a formula in cell B1:
=IF(AND(E1>95,E1<100),"yellow","")

You can, if you wish, use both approaches in parallel, and put the word
yellow and change the colour of the cell.

[As you have ben struggling to ask your question in such as way as to get
the reply you are looking for, try reading the advice at
http://www.cpearson.com/excel/newposte.htm]

 

[james]

Thanks David it worked. Its been great knowing you