I am quiet new with excel. Please can anyone help me with writing a formular
for a cell that contains a range of numbers. I the cell to for example
indicate red if a value in another cell is say between 90 and 100 and another
example that says for example
85<=X<=95

Thanks

For Format/ Conditional Formatting you can either use "Cell Value Is" /
Between ...
or you can use "Formula Is" =AND(A1=85,A1<=95)
--
David Biddulph

"james" wrote in message
...
I am quiet new with excel. Please can anyone help me with writing a
formular
for a cell that contains a range of numbers. I the cell to for example
indicate red if a value in another cell is say between 90 and 100 and
another
example that says for example
85<=X<=95

Thanks

thanks david but i tried the formula and its not working

"David Biddulph" wrote:

For Format/ Conditional Formatting you can either use "Cell Value Is" /
Between ...
or you can use "Formula Is" =AND(A1=85,A1<=95)
--
David Biddulph

"james" wrote in message
...
I am quiet new with excel. Please can anyone help me with writing a
formular
for a cell that contains a range of numbers. I the cell to for example
indicate red if a value in another cell is say between 90 and 100 and
another
example that says for example
85<=X<=95

Thanks

Did you adjust the A1 in David's formula to the cell that you are testing
against?

And you used conditional formatting? And you set the pattern colour in CF
for conditions that meet?

--
---
HTH

Bob


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



"james" wrote in message
...
thanks david but i tried the formula and its not working

"David Biddulph" wrote:

For Format/ Conditional Formatting you can either use "Cell Value Is" /
Between ...
or you can use "Formula Is" =AND(A1=85,A1<=95)
--
David Biddulph

"james" wrote in message
...
I am quiet new with excel. Please can anyone help me with writing a
formular
for a cell that contains a range of numbers. I the cell to for example
indicate red if a value in another cell is say between 90 and 100 and
another
example that says for example
85<=X<=95

Thanks

Yes I did the main problem is getting the others go blank and having the
return with the range of values show up.

"Bob Phillips" wrote:

Did you adjust the A1 in David's formula to the cell that you are testing
against?

And you used conditional formatting? And you set the pattern colour in CF
for conditions that meet?

--
---
HTH

Bob


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



"james" wrote in message
...
thanks david but i tried the formula and its not working

"David Biddulph" wrote:

For Format/ Conditional Formatting you can either use "Cell Value Is" /
Between ...
or you can use "Formula Is" =AND(A1=85,A1<=95)
--
David Biddulph

"james" wrote in message
...
I am quiet new with excel. Please can anyone help me with writing a
formular
for a cell that contains a range of numbers. I the cell to for example
indicate red if a value in another cell is say between 90 and 100 and
another
example that says for example
85<=X<=95

Thanks

I don't understand what you mean. What does '... other go blank ...' refer
to, and what does '... return with the range of values show up ...' mean?

--
---
HTH

Bob


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



"james" wrote in message
...
Yes I did the main problem is getting the others go blank and having the
return with the range of values show up.

"Bob Phillips" wrote:

Did you adjust the A1 in David's formula to the cell that you are testing
against?

And you used conditional formatting? And you set the pattern colour in CF
for conditions that meet?

--
---
HTH

Bob


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



"james" wrote in message
...
thanks david but i tried the formula and its not working

"David Biddulph" wrote:

For Format/ Conditional Formatting you can either use "Cell Value Is"
/
Between ...
or you can use "Formula Is" =AND(A1=85,A1<=95)
--
David Biddulph

"james" wrote in message
...
I am quiet new with excel. Please can anyone help me with writing a
formular
for a cell that contains a range of numbers. I the cell to for
example
indicate red if a value in another cell is say between 90 and 100
and
another
example that says for example
85<=X<=95

Thanks

Well let me try to be clear. I need a formular that says any value between 90
and 100 in cell E1 should make cell A1 indicate the word "green" otherwise it
should be blank
Any value between 80 and 89 in E1 should make B1 indicate the word "yellow"
otherwise it should be blank
Any value less than 80 in E1 should make C1 indicate the word
"red".Otherwise it should be blank.

Hope this helps in your helping me.
"Bob Phillips" wrote:

I don't understand what you mean. What does '... other go blank ...' refer
to, and what does '... return with the range of values show up ...' mean?

--
---
HTH

Bob


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



"james" wrote in message
...
Yes I did the main problem is getting the others go blank and having the
return with the range of values show up.

"Bob Phillips" wrote:

Did you adjust the A1 in David's formula to the cell that you are testing
against?

And you used conditional formatting? And you set the pattern colour in CF
for conditions that meet?

--
---
HTH

Bob


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



"james" wrote in message
...
thanks david but i tried the formula and its not working

"David Biddulph" wrote:

For Format/ Conditional Formatting you can either use "Cell Value Is"
/
Between ...
or you can use "Formula Is" =AND(A1=85,A1<=95)
--
David Biddulph

"james" wrote in message
...
I am quiet new with excel. Please can anyone help me with writing a
formular
for a cell that contains a range of numbers. I the cell to for
example
indicate red if a value in another cell is say between 90 and 100
and
another
example that says for example
85<=X<=95

Thanks

Hi James,

In A1 enter..

=IF(AND(E189.99,E1<100.01),"Green","")

In B1 enter...

=IF(AND(E179.99,E1<89.01),"Yellow","")

In C1 enter...

=IF(E1<79.99,"Red","")

Hope this helps..

Regards,

Gav.



"james" wrote:

Well let me try to be clear. I need a formular that says any value between 90
and 100 in cell E1 should make cell A1 indicate the word "green" otherwise it
should be blank
Any value between 80 and 89 in E1 should make B1 indicate the word "yellow"
otherwise it should be blank
Any value less than 80 in E1 should make C1 indicate the word
"red".Otherwise it should be blank.

Hope this helps in your helping me.
"Bob Phillips" wrote:

I don't understand what you mean. What does '... other go blank ...' refer
to, and what does '... return with the range of values show up ...' mean?

--
---
HTH

Bob


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



"james" wrote in message
...
Yes I did the main problem is getting the others go blank and having the
return with the range of values show up.

"Bob Phillips" wrote:

Did you adjust the A1 in David's formula to the cell that you are testing
against?

And you used conditional formatting? And you set the pattern colour in CF
for conditions that meet?

--
---
HTH

Bob


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



"james" wrote in message
...
thanks david but i tried the formula and its not working

"David Biddulph" wrote:

For Format/ Conditional Formatting you can either use "Cell Value Is"
/
Between ...
or you can use "Formula Is" =AND(A1=85,A1<=95)
--
David Biddulph

"james" wrote in message
...
I am quiet new with excel. Please can anyone help me with writing a
formular
for a cell that contains a range of numbers. I the cell to for
example
indicate red if a value in another cell is say between 90 and 100
and
another
example that says for example
85<=X<=95

Thanks