Hi, I asked this question a few days ago but I didn't really get any reply I
could use, so in the hope someone understands my question, here goes:

I have a spreadsheet in to which users type measurements, each row being
related to one asset. However, throughout the length of the asset several
measurements are taken.

What I would like to do, is for each asset, look through the measurements
entered for that asset, some 8 columns which are incidentally not
consecutively laid out, and tell me the following three conditions:

1. any occurence of values between 1439 and 1449
2. any occurence of values greater than, or equal to, 1450
3. any occurence outside these values

Conditional formatting would be my starting point but if an asset passes on
the first column, how do I get Excel to check the remaining values entered
for that asset?

Thank you for your patience, help and understaning in advance.

Phil