Conditional statements

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

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)



"james" wrote in message
...
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

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

On Jan 7, 10:48*am, james wrote:
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

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.


"Pete_UK" wrote:

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

On Jan 7, 10:48 am, james wrote:
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

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.


"Bob Phillips" wrote:

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)



"james" wrote in message
...
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

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

"james" wrote in message
...
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.


"Pete_UK" wrote:

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

On Jan 7, 10:48 am, james wrote:
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

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

"David Biddulph" wrote:

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

"james" wrote in message
...
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.


"Pete_UK" wrote:

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

On Jan 7, 10:48 am, james wrote:
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

Sorry David but I am not getting any results

"David Biddulph" wrote:

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

"james" wrote in message
...
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.


"Pete_UK" wrote:

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

On Jan 7, 10:48 am, james wrote:
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

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(E195,E1100),"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]
--
David Biddulph

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

"David Biddulph" wrote:

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

"james" wrote in message
...
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.


"Pete_UK" wrote:

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

On Jan 7, 10:48 am, james wrote:
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

Thanks David it worked. Its been great knowing you

"james" wrote:

Sorry David but I am not getting any results

"David Biddulph" wrote:

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

"james" wrote in message
...
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.


"Pete_UK" wrote:

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

On Jan 7, 10:48 am, james wrote:
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