I have a sheet for calculating a bunch of values for allocating
resources among 2 or more people. The sheet has some limits on the
maximum values for certain results. For example, there may be a limit
of 10 pounds on some product. The actual allocations are determined by
various calculations such that it is possible for one of the results
to exceed the limit.

I would like to flag or highlight any results that are over the limit.
I don't especially care how this is done, but the cell needs to show
the incorrect value so I know how to make adjustments.

Probably the easiest method is to turn the cell data red.

I don't want to use the Text function because the cell contents may be
used in further calculations.

A further complication is that for some cells, there is more than one
possible error. The value could be over the limit or it might conflict
with some other value. Is there a way to generate multiple errors?

Thanks