IF function problem

[Krista]

Is it possible to do all the below, but put it in an
inactive cell, so you can set the whole column to work?
And if you do use inactive cells, can you put more than
one rule on a column?

thanks

-----Original Message-----
you are an absolute genious! it works perfectly! thankyou
so much!

Krista
.

..