It will be a conditional format. A cf wants either a true or false answer. So
for your example this formula should do

=and(D894, D8<97)

which will colour the cell based on your formatting choice when D8 is
between 94 and 97...
--
HTH...

Jim Thomlinson


"edward/" wrote:

I know this has been beat to death but I just cant seem to figure it out.

This is what I want to do

=IF(94<D8<97,[change cell color to red],[do nothing])

I have tried the conditional formatting but the value in D8 is referenced
from another page in the same worksheet.

How can I get this to work?

Thanks.