Formula
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
|