Try {IF(A1<9,A1,"")}, in a separate column of use the conditional formatting
to change the color or highlight the field if it doesn't equal $100.

"Russell" wrote:

I want to be able to search for two things in a column. The first is a value
of less than or greater than $100. (OK so that is really two things I guess).
The second is to be able to see if that amount is within the previous 365
days. There is another column for the date. I can get part to work but am
having trouble with the date. Any ideas would be greatly appreciated.