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