Formula

[james]

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

 

[David Biddulph]

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

 

[james]

thanks david but i tried the formula and its not working

 

[Bob Phillips]

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]

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]

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]

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.

 

[Gav123]

Hi James,

In A1 enter..

=IF(AND(E1>89.99,E1<100.01),"Green","")

In B1 enter...

=IF(AND(E1>79.99,E1<89.01),"Yellow","")

In C1 enter...

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

Hope this helps..

Regards,

Gav.