im gonna do my best to explain this.

i am an estimator for a construction company. we get several bids from many different trades for each job we bid. (electrical, framing, drywall, etc.)
alot of times these bids are broken out in detail.

lights - $35,000.00
Wire - $5,000.00
Conduit - $3,500.00

sort of like that. but we will get several bids from electricians broken out the same way. eventually after entering in all the electricians you can see a trend in the prices for that job example ( lights will range from $25,000.00 to $35,000.00)

well the other day i made a typo and didnt catch it.

Electric company 1 | Electric Company 2 | Electric Company 3
Lights - $25,000.00 | $ 32,000.00 | $3,500.00 < Typo
Wire - $5,000.00 | $ 4,500.00 | $ 6,000.00


i hope you get the idea now.

my question is:

is there some kind of conditional formating code that will look at the range of numbers for a particular line item and determine if one just doesnt fit the trend of those numbers and then highlight that number to be double checked? like the $3,500.00 typo in the lights catagory.

thanks for any help.