I posted this question a few days ago but didn't really get anything I could
use, so in an attempt to phrase my question better, here goes:

I have a spreadsheet in to which users enter measurements. Each row is for
an individual asset, however, there are 8 readings entered on the row for
measurements along a particular asset. The columns are not sequential either!

I need a method which will:

1. Tell me of any values greater than or equal to 1439, but less than or
equal to 1449
2. Tell me of any values greater than or equal to 1450
3. Tell me of any values less than 1439.

I had thought conditional formatting would be the way ahead but I can't work
out how to get Excel to look along the row, rather than in just one cell.

Your help and patience is greatly appreciated.

Phil