You should responded back to your post and tell why the formulas provided
doesn't
work for you. Nevertheless, try these, place these into 3 different cells

1) 1st condition : =IF(AND(A2=1439,A2<=1449),A2,"outside this range")
2) 2nd condition : = IF(A2=1450,A2,"this is <1450")

Having the above two formula, you actually don't need another formula for
your
3rd condition, but you need, try

3) 3rd condition : =IF(AND(A2=1439,A2<=1449,A21450),A2,"check values")

Is this what you want? if not, post back with a sample of data table and
your expected result...all shown in the post for us to understand your
requirements.

HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis









"PhillyD" wrote:

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