Useing IF statements to change a cell color

  • Thread starter Thread starter edward/
  • Start date Start date
E

edward/

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.
 
It will be a conditional format. A cf wants either a true or false answer. So
for your example this formula should do

=and(D8>94, D8<97)

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