Im trying to set up a spreadsheet that will indicate whether or not a value
is acceptable or rejectable based on a given value. In example.... say that
a certain value needs to be between 3.0 and 5.0..... if the value is 2.9 or
below / 5.1 or above, it will automatically fill in a seperate cell with an
"X". And if the value falls between 3.0 and 5.0 it will fill in a different
cell with a "check mark".

I was able to accomplish this, however it was several years ago and I dont
have the first clue as to how I go about this.

Can anyone please help?????

CORRECTION:
Im trying to set up a spreadsheet that will indicate whether or not multiple
values are acceptable or rejectable for percentages entered for a single line
..

In example....

Percentages entered into A1, B1, and C1 needs to be between 3.0 and 5.0.....
if the value is 2.9 or below / 5.1 or above in any cell, it will
automatically fill in E1 with an "X". And if percentage entered is 3.0 and
5.0 it will fill in D1 with a "check mark" (if possible).