?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."