how do I set up a fast comparison table?
 

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.

?B?QmlvbG9naXN0?= wrote:

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). ...

One way is to use conditional formatting.

Suppose column A has the original number and the remaining columns have the
reference numbers.

Select B1 and use:
Format Conditional formatting
This brings up a "conditional formatting" box.

In the pull-down, choose "Formula is" and put
=B1$A1
in the empty field to the right.

Still in the conditional formatting box, click "Format..." and choose a
pattern to your liking and click OK.

Click OK to dismiss the conditional formatting box.

Use the "Format painter" button to copy B1's format to all the columns from
B to Z. (It looks like a paint brush.)

Not quite sure what you want as "reports to another sheet."