I wish to create a worksheet in which I can make fast comparisions.

I enter a number in a column (orginal number), this number will then be
compared to about 20 other numbers(reference numbers) in the same row. When
one of the reference numbers is greater than the original number, it gets
highlighted and then (if possible, reports to another sheet).

The use of this for me is that i can enter in a physical parameter, such as
arsenic concentration or Dissolved Oxygen, and instantly compares it to a
list of know criteria and published guidelines. Will save me lots and lots
of time in my work.