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.