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