Find occurences of specific value
 

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

Find occurences of specific value
 

pls see your other post " Searching for specific values - filter doesn't work "

A solution was provided there


--
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:

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

Find occurences of specific value
 

Duplicate post - closing thread


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60724